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,
Mike.
Create two rules for K18:K19, and two different rules for K23:K24.
They can be of type 'Format only cells that contain'.
