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.

Try using Format, Conditional formatting.

--

Rod Gill

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

Format>Conditional Formatting

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| 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.
|