conditional formatting - using icon for text

[lezawang]

Hi
I understand I can use conditional formatting icons based on cells values. but I am wondering if I can use these icons somehow for text. Fro example I have a column which has "pass" and "fail" text, i want to put red flag if it is fail and green if it is pass, is that possible? thank you so much.

 

[Saba Sabaratnam]

You can do it by using a helper column

Create a table to assign negative and positive numbers to your text

Then enter the following formula in B12 and copy it down as shown below.

=VLOOKUP(A12,$A$1:$B$2,2,FALSE)

Then use conditional formatting as shown below and tick "Show Icon Only"

Kind regards
Saba

 

[aRandomHelper]

If you can change your "pass"/"fail" column text to numbers, like 1 for pass and -1 for fail, you can use conditional formatting plus cell number formatting to look like what you want.

First, set the conditional formatting like you wanted. I just make it green flag for >=0 and red flag for <0.

Next, select the entire column and set to Custom number format, and use this: [=1]"Pass";[=-1]"Fail";

 

[Peter_SSs]

I note that you have marked post #2 as the accepted answer. If you are happy to have the icons in the adjacent column to the text like that then you could do this without the lookup table. Just use the formula shown in the formula bar here in the adjacent column.