What I want to do is........
When I select Yes (or No) in any cell in column K, for example K6, I would
like the range of cells B6:M6 in that row only to change to the
appropriate
colour.
Likewise K8 (Yes / No) would produce formatting on Row range B8:M8.

Yes, implemented correctly, that's exactly how it should have worked.

Did you select the range correctly as per the 1st step ?
Select B6:M20 (with B6 active)

The above means select by clicking on B6 first,
then dragging across/down to M20

The CF settings would then be correctly applied for each row
within the range B6:M20 at one go

Here's a sample construct to illustrate:
http://cjoint.com/?mDpCcXfbmG
Dermot_newusers.xls

(contains a screenshot of the selection & CF dialog settings as well)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Dermot" wrote in message
...
Hi Max,
You resolve one problem for me....I hadn't worked out how to apply two
conditional formats....using the add button.....I don't know how I missed
this...cheers.

Using a range like the one you suggested B6:M6, causes ALL the cells in
the
range to change.....I only want the relevant row to change.....to be used
as
a visual indication of the clients stage progress...if you know what I
mean!

I didn't explain my objective properly Max.
Doing what you suggested conditionally formats all the cells in the range.

What I want to do is........
When I select Yes (or No) in any cell in column K, for example K6, I would
like the range of cells B6:M6 in that row only to change to the
appropriate
colour.

Likewise K8 (Yes / No) would produce formatting on Row range B8:M8.

Do I have to format each row individually. What formula would I use for
this? I thought if I used relative references, I could copy down the
formula...but I don't seem to be able to get this to work.

Please advise.
Thanks
Dermot