View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default IF statement checking if a cell's text is red

Hi Shazzer,

You may be able to adjust this to your needs.
http://xldynamic.com/source/xld.Colo...r.html#sorting

HTH
Martin


"Shazzer" wrote in message
...
I want to say :-
IF the text in A1 is formatted Red then, "yes" else "no"

Is there any way I can do this?

Ta v much