Whole Row Cond. Format

[Guest]

I have an entire row, from A - Q, that hinges on the value in cell B.

Is there a way to have conditional formatting hightlight all cells the the
row, A-Q, when the value of cell B meets the criteria?

 

[Dave Peterson]

Select your range to apply the conditional formatting (say A2:Q999) and with A2
the activecell, just make sure you "anchor" the formula to column B by using $B2
in the formula:

=and($b2>5,$b2<100)

for instance.

 

[Guest]

Worked Great!

I highlighted and wrote the formula and WHAMO! It worked perfectly.


--
Thanks As Always
Rip

Select your range to apply the conditional formatting (say A2:Q999) and with A2
the activecell, just make sure you "anchor" the formula to column B by using $B2
in the formula:

=and($b2>5,$b2<100)

for instance.