Multiple Cells - Data Validation/Conditional Formatting

[ray963]

I have created a cell with "Data Validation" and "Conditional Formatting".

The drop down menu works and when I select one of several choices it places
the data in the cell and also fill colours the cell if the requirements are
met.

e.g.
condition 1
=OR($A$2="YES",$A$2="YES-BUT") choose format ok

This works perfect for that cell, however if I copy and special paste it
into a cell below, it does not work.

.....I understand the $A relates to column A and $2 refers to the cell row.

How can I adjust this formular so that I can copy and special paste it to
multiple cells below it in the same column without interfering with the other
cells.

 

[Sheeloo]

Instead of $A$2 use $A2 if you want it work down the rows...
In fact you can change it to A2 if you are highlighting only Col A
$A2 will change to $A3 when copied down but $A$2 remains $A$2 when painted
down for conditional formatting...