if a certain value is above...colour it?
 

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

if a certain value is above...colour it?
 

Hi ,

One way would be to use Conditional Formating under the Format menu.

Regards,
Bondi

if a certain value is above...colour it?
 

You'll want to use conditional formatting. Click on the cell you want to
have the formatting (CG24), the click FormatConditional Formatting... Set
the condition to "Cell Value Is", "Greater than or equal to", 50. Then click
the format button and, in the "Font" tab select the colour red from the
palette.

"koldtooth" wrote:


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