C
Chris
trying to get font to change when values are above or below set amounts.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Fred Smith
Use conditional formatting. Look it up in help or post back with specific
requirements.
Regards,
Fred.
requirements.
Regards,
Fred.
O
Otto Moehrbach
Go into help and look up Conditional Formatting. HTH Otto
C
Chris
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.
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.
G
Gord Dibben
Select the cell with the formula.
Format>CF
Condition 1>Cell Value is: Check Tank Volume
Condition 2>Cell Value is: Tank Volumes OK
Gord Dibben MS Excel MVP
Format>CF
Condition 1>Cell Value is: Check Tank Volume
Condition 2>Cell Value is: Tank Volumes OK
Gord Dibben MS Excel MVP