| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you use a formula to fill cells with color?
Here is the formula that I use to keep track of daily spending:
=IF(B3<1,"Awesome",IF(B3<10,"Great Job",IF(B3<25,"Be Careful",IF(B3<1000,"See Comment","-")))) Is it possible to add color to the cells as well? For example: "See Comment" in a red cell and "Be Careful" in an orange cell. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you use a formula to fill cells with color?
Try using Format, Conditional formatting.
-- Rod Gill wrote in message oups.com... Here is the formula that I use to keep track of daily spending: =IF(B3<1,"Awesome",IF(B3<10,"Great Job",IF(B3<25,"Be Careful",IF(B3<1000,"See Comment","-")))) Is it possible to add color to the cells as well? For example: "See Comment" in a red cell and "Be Careful" in an orange cell. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can you use a formula to fill cells with color?
FormatConditional Formatting
-- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message oups.com... | Here is the formula that I use to keep track of daily spending: | | =IF(B3<1,"Awesome",IF(B3<10,"Great Job",IF(B3<25,"Be | Careful",IF(B3<1000,"See Comment","-")))) | | Is it possible to add color to the cells as well? For example: "See | Comment" in a red cell and "Be Careful" in an orange cell. | | Thanks. | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use an if formula to fill cells with color | Excel Worksheet Functions | |||
| color fill cells based on IF function or formula | Excel Worksheet Functions | |||
| My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Linear Mode
