CF is conditional formatting. Follow the steps I gave, it is complete.
FormatConditional Formatting means take the Format menu, then take
Conditional Formatting off that menu.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Irv" wrote in message
...
Thanks Bob, however can you please provide a bit more details.. (ex. What
is
and where do I find, CF?)

"Bob Phillips" wrote:

Try conditional formatting.

Select B3:F15
Goto CF, FormatConditional Formatting
Change Condition 1 to Formula Is
Add a Formula =OR($D3="no",$F3="no")
Click format
Select Pattern
Choose a colour
OK

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Irv" wrote in message
...
Hi, I'm trying to build a formula that would take the content of a
cell
and
compare it to the value (yes or no), of a range of cells, then show
the
cell
reference (column/row#) if the cell reference does not meet the given
criteria. Ex....
if... Column A, Rows 3-15 contains the letter "B"
then... Columns "D and/or F" (rows 3-15) should contain "yes", However
if... any of the rows contains "no" in both columns (D & F), then show
which
row..