| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using the IF function to automatically change the color of the fon | Excel Discussion (Misc queries) | |||
| data change color automatically | Excel Worksheet Functions | |||
| Why does my color palette automatically change? | Excel Worksheet Functions | |||
| How do I automatically change color of value if value is > 50 in . | Excel Discussion (Misc queries) | |||
| How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
Linear Mode
