View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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.
|