conditional formatting
 

I have a problem in Excell, which I need to fix ASAP. Please help me on this.
Pl. if possible respond to me at .

In excell, if say cell A1 is having color RED, then I Want cell B3 to be RED
aswell. HO w to do this. Also How to count All RED cells in a column or row??
Thanks

conditional formatting
 

Do you presently have conditional formatting assigned in Cell A1 (producing
the Red)? If so, why not use the same technique with cell B3's conditional
formatting?

"sanjay D." wrote:

I have a problem in Excell, which I need to fix ASAP. Please help me on this.
Pl. if possible respond to me at .

In excell, if say cell A1 is having color RED, then I Want cell B3 to be RED
aswell. HO w to do this. Also How to count All RED cells in a column or row??
Thanks

conditional formatting
 

Use the Formula Is, rather than Cell Value Is, option in Conditional
Formatting.
--
David Biddulph

"sanjay D." wrote in message
...
I have a problem in Excell, which I need to fix ASAP. Please help me on
this.
Pl. if possible respond to me at .

In excell, if say cell A1 is having color RED, then I Want cell B3 to be
RED
aswell. HO w to do this. Also How to count All RED cells in a column or
row??
Thanks