Thread: how to change font colour for values. eg if value < 10 red, gre.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
  
Posts: 788
Default how to change font colour for values. eg if value < 10 red,
Formula is. =if(d7="","",if($q$5-d7=46.5,Check Tank
Volumes",if($q$5-d7<=46.5,"Tank Volumes OK"))) . I need to show "Check Tank
volumes" in red and "TankVolumes OK" in green.
Regards
Chris.

"Fred Smith" wrote:

Use conditional formatting. Look it up in help or post back with specific
requirements.

Regards,
Fred.

"Chris" wrote in message
...
trying to get font to change when values are above or below set amounts.


Reply With QuoteReply With Quote