Select all the A cells to have this CF. I will assume the first one is A2
Use -- Formula Is =B2=1 and set the formatting as needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"GD" wrote in message
...
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