Conditional Formatting to Highlight Entire Row

[nirvehex]

Hi, I'm trying to figure out a way to highlight an entire row green if the value in column AY=1020.

Any idea how to use conditional formatting to do this? Or another easier way?

Thanks!

 

[nirvehex]

Thanks All! Perhaps I need to run this as a macro? As the conditional formatting should apply to cells A2 to CK and last row. The number of rows varies each time.

Anyway to code this with VBA? Or shouldn't that matter?

 

[Fluff]

No VBA needed.
Select A2 to CK last row & use this formula
=$AY2=1020

 

[nirvehex]

Hi, that actually did work. I basically set the formula =$AY2=1020 with the format of green fill, and applies to: $a$2:$ck. Then when my rows get inserted it keeps getting added to each row.

One final question: How do I get the formula which drives this to say =$AY2=1020 & =$AQ>5?

Thanks!

 

[Fluff]

how about
=and($ay2=1020,$aq2>5)