Conditional Formatting
 

Is there a way to use conditional formatting in Excel so that if, for
example, cell B2 equals a certain value, then a range of cells B2:B10 will be
conditionally formatted to include a yellow fill color?

--
Gail

Conditional Formatting
 

You may disregard - I discovered that I needed the $B$2 to make the formula
work.

--
Gail


"Gail" wrote:

Is there a way to use conditional formatting in Excel so that if, for
example, cell B2 equals a certain value, then a range of cells B2:B10 will be
conditionally formatted to include a yellow fill color?

--
Gail