Forum Discussion

Mikeroller's avatar
Mikeroller
Copper Contributor
Oct 03, 2023

Conditional formatting

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.

 

 

 

2 Replies

Resources