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