CF

[Parag]

The sheet I am using looks something like this.How can I use CF on cell A1
and B1 using the reference of value in cell D1? Meaning if D1=1, A1 and B1
should be green?
Thanks.

A B C D
1 A1 B1 C1 D1
2
3
4

 

[David Biddulph]

For A1 & B1, CF/ Formula Is/ =$D1=1

 

[Max]

Select cols A and B (A1 active),
then apply CF using Formula Is: =$D1=1
Format to taste, ok out
(The "$" sign will fix the CF trigger to col D)

Test it out .. when you enter 1 anywhere in col D,
the corresponding cells in col A and B will be cond-formatted