Having a value automatically change color

[John]

I'm setting up a blood pressure monitoring worksheet, and would like to have
one one of the values turn red if it is over 80. I have no idea how to do
this. Help?? Please?

 

[Gary''s Student]

Say the cell is B9. Click on it and pull-down:

Format > Conditional Formatting... > Cell Value > Is Greater than > 80
and pic a distinctive format.

 

[Shane Devenshire]

Hi,

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, Highlight Cell Rules, Greater Than
and enter the 80.
3. Open the with dropdown and choose Custom Format, OK.
4. On the Font tab open Color and choose Red.
5. Click OK twice

 

[John]

Thanks a million...

Say the cell is B9. Click on it and pull-down:

Format > Conditional Formatting... > Cell Value > Is Greater than > 80
and pic a distinctive format.

 

[John]

Thanks Shane, Really appreciate the help..
John

Hi,

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, Highlight Cell Rules, Greater Than
and enter the 80.
3. Open the with dropdown and choose Custom Format, OK.
4. On the Font tab open Color and choose Red.
5. Click OK twice
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Shane Devenshire]

You are welcome, thanks for the feedback.