| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement checking if a cell's text is red
Create a named range (Insert ~ Name ~ Define)
In the Define Name dialog box enter a name in the 'Names in workbook:' box (e.g. RedCell). In the 'Refers to:' box enter this formula: =IF(GET.CELL(63,Sheet1!$A$1)=3,"Yes","No") alternatively use: =IF(GET.CELL(63,INDIRECT(ADDRESS(0,-1,4,FALSE),FALSE))=3,"Yes","No") which will return Yes if the cell to the immediate left of the cell containing the formula is red (change the 0 & -1 to refer to different rows/columns). Regards, Darren. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement Checking Formula NOT Value in a Cell | Excel Discussion (Misc queries) | |||
| Can a cell's text order be ahead of a drawn item? | Excel Discussion (Misc queries) | |||
| VLOOKUP based on PART of another cell's text | Excel Discussion (Misc queries) | |||
| How do I use a cell's text, "A1", and put it in a formula? | Excel Worksheet Functions | |||
| How can I change a text to a cell's address? | Excel Discussion (Misc queries) | |||
Hybrid Mode
