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.

--
ray963