Having a value automatically change color
 

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?

Having a value automatically change color
 

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.
--
Gary''s Student - gsnu200830


"John" wrote:

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?

Having a value automatically change color
 

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


"John" wrote:

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?

Having a value automatically change color
 

Thanks a million...

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200830


"John" wrote:

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?

Having a value automatically change color
 

Thanks Shane, Really appreciate the help..
John

"Shane Devenshire" wrote:

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


"John" wrote:

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?

Having a value automatically change color
 

You are welcome, thanks for the feedback.

--

Cheers,
Shane Devenshire


"John" wrote:

Thanks Shane, Really appreciate the help..
John

"Shane Devenshire" wrote:

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


"John" wrote:

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?