View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fak119 fak119 is offline
external usenet poster
 
Posts: 21
Default Formula "do if red": Possible?

I have highlighted some amounts in red.

Is there a formula that recognizes the colour of the font, e.g.

IF(A45=red (is in red colour);1;2) ?