Advertisement
Guest User

Untitled

a guest
Oct 25th, 2014
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. Function GetCellColour(r As Range) As Long
  2. GetCellColour = r.Cells(1, 1).Interior.Color
  3. End Function
  4.  
  5. Function GetCellColourIndex(r As Range) As Long
  6. GetCellColourIndex = r.Cells(1, 1).Interior.ColorIndex
  7. End Function
  8.  
  9. =IF(GetCellColour(A1)=65535,"Cell is yellow","")
  10.  
  11. =IF(GetCellColourindex(A2)=6,"Cell is yellow","")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement