| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if 3 cells have data then add certain value to another cell
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if 3 cells have data then add certain value to another cell
.. 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if 3 cells have data then add certain value to another cell | Excel Worksheet Functions | |||
| Send multi data (Graph/Cell data) to Word doc as 1 item (no cells) | Excel Discussion (Misc queries) | |||
| Converting data in one cell to 3 different cells | Excel Worksheet Functions | |||
| How to combine 2 cells' data into 1 cell? | Charts and Charting in Excel | |||
| Cell data overruns into adjacent cell(cells). | Excel Discussion (Misc queries) | |||
Linear Mode
