Hi,

I'm trying to conditional format adjacent cells on my worksheet, For
example please see table below:

Emp No Name DOB Dept Grade Decision
12345 Rachel 28/02/78 HR A Yes
45678 Ian 15/10/71 Head Office B Yes
55678 James 15/11/81 Finance C No
55678 John 11/09/78 Finance A Yes
48567 Matt 20/09/56 HR B No

I somehow need to check what is present in the decision column (F) and
depending on whether the result is Yes or No colour format the rest of
the row of data. For example I want all Yes to be red and all No's to be
green. When i attempt to format in code the cell with the Yes/No
in it is the only cell that gets formatted - how can i format the
whole row depending on the result in column F (decision).

Also,

How do i select one row after another and how can you tell the
computer when it has reached a row with no text present.

Any help would be greatly appreciated.

R Curran