if 3 cells have data then add certain value to another cell
=AND($A$1="y",$B$1="y",$C$1="y")
"Gerigto" wrote:
I would like to make cell D1 be blacked out if cells A1, B1 and C1 have a Y
in them. How do I accomplish this? Some people may enter data into D1 first
and thus eliminate any If,then formula I enter into that cell. Is there
another way around this issue?
--
TG
|