Select the cell with the formula.

FormatCF

Condition 1Cell Value is: Check Tank Volume

Condition 2Cell Value is: Tank Volumes OK


Gord Dibben MS Excel MVP

On Sun, 30 Aug 2009 11:36:01 -0700, Chris
wrote:

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.