Conditional formatting, based on a different cell?
Select column A and enter =B1=1 in CF formula field! Choose yellow pattern!
Regards,
Stefi
€žGD€ ezt Ã*rta:
Is it possible to use conditional formatting on one cell, based on the value
or conditions in another cell? In other words, if I wanted the cells in
column A to have a yellow fill color for every row that has a value of 1 in
column B, what kind of formula would I use in conditional formatting to
accomplish this?
Any help? Thanks!
--
GD
|