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

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