conditional formatting

S

sanjay D.

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

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
 
J

JMay

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?
 
D

David Biddulph

Use the Formula Is, rather than Cell Value Is, option in Conditional
Formatting.
 
Top