Easy. Select col A, then apply CF using Formula Is:
=$B1=1
Format yellow fill, ok out
The $ sign is the key here to fixing the point to col B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"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?