if 3 cells have data then add certain value to another cell

G

Gerigto

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

Max

.. make cell D1 be blacked out if cells A1, B1 and C1 have a Y in them.

Perhaps try applying conditional formatting on D1 ..

Select D1
Click Format > Cond Formatting,
Under Condition 1, make the settings as
Formula is:
=COUNTIF(A1:C1,"Y")=3
Click Format > Patterns tab > Black > OK
Click OK at the main dialog
 
Top