Conditional formatting

Copper Contributor

Hi, I've formatted four cells to turn red or green which works fine - if the two crosses match they turn green and if the two ticks match they turn green, otherwise I get red cells.


Trouble is, if I then remove the $ reference from the conditional format formula (just the column reference so that I can copy the section of the spread sheet to a new location directly below), the conditional formatting goes awry :-


This is the formula:-


Can anyone help me please? I really don't see what I'm doing wrong.


Kind regards,






2 Replies


Create two rules for K18:K19, and two different rules for K23:K24.

They can be of type 'Format only cells that contain'.


@Hans Vogelaar 

Hi Hans,

Thank you so much, that's worked perfectly.

Best regards,