| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Colors
What do I do, to make cells different colors based on a number I enter. What
I want to do is any number less than 72 the cell will be red. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Colors
Format conditional formatting, formula is
=A1<72 click format button and select colour, click OK twice, now put a number less than 72 in A1 -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Tommy" wrote in message ... What do I do, to make cells different colors based on a number I enter. What I want to do is any number less than 72 the cell will be red. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Colors
thank you it worked perfect.
"Peo Sjoblom" wrote: Format conditional formatting, formula is =A1<72 click format button and select colour, click OK twice, now put a number less than 72 in A1 -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Tommy" wrote in message ... What do I do, to make cells different colors based on a number I enter. What I want to do is any number less than 72 the cell will be red. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Colors
Hi Tom...this is called conditional formating.
"Tommy" wrote: What do I do, to make cells different colors based on a number I enter. What I want to do is any number less than 72 the cell will be red. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Excel: is there a way I can lighten the fill colors in a cell? | Excel Discussion (Misc queries) | |||
| Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| How to add fill colors (cell shading) in EXCEL? | Excel Discussion (Misc queries) | |||
Linear Mode
