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?