Conditional Formatting

[Gail]

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]

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