how to get colored outputs from a nested IF function

**dsklein85** · 01-16-2012, 10:48 AM

Hi,

I was wondering if the following is possible to do. In cell A3 I have the following nested IF function:

=IF(A1<60,"bad",IF(A1<80,"okay",IF(A1<90,"good","excellent")))

I am wondering if it is possible to have the respective outputs have there own colors. ie. when bad is displayed in cell A3 it would be in the color red, when okay is displayed it would be color yellow, good would be color green, and excellent would be color blue.

Thanks,

Dan

**NBVC** · 01-16-2012, 10:52 AM

Select A1 and go to Home|Conditional Formatting New Rule.

Select Format Only Cells That Contain... from the top

Select: Cell Value >> Is Equal To >> and then enter ="bad"

Click Format and choose from Fill tab.

Click Ok, then click New Rule and repeat for each word/colour.