Forum Discussion
Conditional formatting
I’ve applied a conditional format to a row, so that if a specified cell has ‘Y’ entered, the whole row goes green. How do I apply this formatting to every row, without going through each row individua...
Hi Sarah,
Do you mean if any cell in the row is equal to Y then entire row is green?
A and B are not rows, they are columns
If rows you may apply the rule with the formula
=COUNTIF(1:1,"Y")
to =$1:$1048576 range
Yes, sorry I meant rows 1 and 2.
Great thanks, I’ll give that a go!
Great thanks, I’ll give that a go!