ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - CF (https://www.excelbanter.com/excel-worksheet-functions/183412-cf.html)

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

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Parag" wrote:
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