View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary
 
Posts: n/a
Default If statement to test font color

I have seen this question in reverse on the forum. Usually the question is
to change the font color when criteria is met.

I need to test the font color in order to determine value. I can do it in
code with a for..next loop but I was wondering if it could be done in an if
statement?

Example: If(fontcolor (A2) = "Red", then "Next Day", "Standard")

What would be the syntax?

Thanks for the help.