Using conditional formatting with IF formula

[chrisellis250]

Hello all,

In cells B:F I have the following statement:

=IF(COUNTIFS('Data to Import'!$A$2:$A$30,$A6,'Data to Import'!$B$2:$B$30,B$5)>0,"a","r")

Which changes along each cell.

Ultimately, I want the letter r in each cell to be shown as red and the a in each cell to be shown as green. I cannot seem to get this to work when using the rule of containing the letter r or a etc.

Can CF not be used where the cell value is a formula?

[Fluff13]

How about
=B2="a"
and
=B2="r"

Change B2 to the topleft cell in the applies to range

[romperstomper]

CF works fine with formula cells, so you must have implemented something wrongly.

[chrisellis250]

Yep, got there in the end. Wouldn't work at first, so wasn't sure that as the cell was a formula whether it would work with CF. Many thanks.

[Fluff13]

Glad we could help & thanks for the feedback