Conditional formatting

[Sarah Thacker]

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 individually?

I’ve tried all the paste special suggestions etc, but the formatting gets applied so that (for example) if cell A1 has Y, every cell on the spreadsheet goes green. I want it so that if A1 has Y, row A goes green; if B1 has Y, row B goes green, and so on.

[#2]

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

[#3]

Yes, sorry I meant rows 1 and 2.

Great thanks, I’ll give that a go!

[#4]

Hi,

That's worked!

Thanks very much for your help :)

[#5]

You are welcome