ok i am doing a spreadsheet of working hours, and i have the following
formula in the cells:

='Daily Hours'!CG24

is there anyway to add a formula in there so that when it reaches a
value of, lets say 50 hours, it changes the text colour to red?

or is there a lookup formula that checks to see any values above 50 and
then colour them red?

any help would be great!!

thanks!


--
koldtooth
------------------------------------------------------------------------
koldtooth's Profile: http://www.excelforum.com/member.php...o&userid=35406
View this thread: http://www.excelforum.com/showthread...hreadid=552188