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