| 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
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("D1").FormulaR1C1 = _ "=IF(RC[-3]=""Y"","""",IF(RC[-2]=""Y"","""", " _ & "IF(RC[-1]=""Y"","""",""NO Y IN A1 B1 OR C1"")))" End Sub "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 | |||
| 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 | |||
| How do you merge data from numerous cells into just one cell? | Excel Discussion (Misc queries) | |||
| Cell data overruns into adjacent cell(cells). | Excel Discussion (Misc queries) | |||
Linear Mode
