Conditional formatting, based on a different cell?
 

Let's say I want column A to be formatted with a yellow fill color, if the
value of column B (same row) is 1. Can this be done with a formula in
conditional formatting? If so, can you provide it?

Thanks!!
--
GD

Conditional formatting, based on a different cell?
 

Select the A column and open up Conditional formatting. =$B1=1.
--
Carrie


"GD" wrote:

Let's say I want column A to be formatted with a yellow fill color, if the
value of column B (same row) is 1. Can this be done with a formula in
conditional formatting? If so, can you provide it?

Thanks!!
--
GD