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.

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.

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.
|