CF

  • Thread starter Thread starter Parag
  • Start date Start date
P

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
 
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
 
Back
Top