Thread: Can you use a formula to fill cells with color?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bjp1965@gmail.com is offline
external usenet poster
  
Posts: 4
Default 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.

Reply With QuoteReply With Quote