How do I extend this formula so ................
1. No = Red
2. All cells in column K behave in this manner?

One way ..

Assume the range to be cond formatted is B6:M20

Select B6:M20 (with B6 active)

Click Format Cond Formatting

Make the settings as

Cond1:
Formula is:=$K6="Yes"
Format: Yellow

Click "Add"

Cond2:
Formula is:=$K6="No"
Format: Red

OK out
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--