Formula Conditional Formatting for multiple rows

[akshay0880]

hello, I have a table of 500 rows
starts Row 6 to Column J
in A6, I have a dropdown list (completed, waiting)
I have applied a conditional formatting so that when i pick
1. Completed, $A$6:$J$6 is highlighted in Green
2. Waiting, $A$6:$J$6 is highlighted in Yellow.

I need to repeat this for all the rows below. Column A will all have the same dropdown and i want it to highlight the same depending on 'completed' or 'waiting'

Is there a way I could do this without creating multiple conditional formatting rule for each row?
I tried Copy/Paste Formats or All Merging Conditional formatting but it does not work.

Maybe a VBA code would do it?

Thanks in advance

 

[Fluff]

If you select A6:J500 & use this formula for Green

=$A6="Completed"

then it will work for every row.

 

[akshay0880]

If you select A6:J500 & use this formula for Green

=$A6="Completed"

then it will work for every row.

That worked! thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.