Thread: Formula "do if red": Possible?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
The Fool on the Hill The Fool on the Hill is offline
external usenet poster
  
Posts: 58
Default Formula "do if red": Possible?
Hey Fak,

Is there a particular reason why the amounts are in red?

Because if the amounts are less than 0, you could use
IF(A45<0;1;2) .

"fak119" wrote:

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) ?
Reply With QuoteReply With Quote