Forum Discussion
Mikeroller
Oct 03, 2023Copper Contributor
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...
HansVogelaar
Oct 03, 2023MVP
Create two rules for K18:K19, and two different rules for K23:K24.
They can be of type 'Format only cells that contain'.
Mikeroller
Oct 03, 2023Copper Contributor