F Fred Smith Aug 30, 2009 #2 Use conditional formatting. Look it up in help or post back with specific requirements. Regards, Fred.
Use conditional formatting. Look it up in help or post back with specific requirements. Regards, Fred.
C Chris Aug 30, 2009 #4 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.
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.
G Gord Dibben Aug 30, 2009 #5 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
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
