| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change different cell based on conditional statement
Post back if you need help with the code
"FoxIII" wrote: Thanks for the reply. It was helpful, but I guess I'm gonna have to resort to VB as the whole reason for trying to do this is that B14 must not hold a formula. Thanks though. I'll go dive into VB. "Mike H" wrote: Hi, Excel formula cannot 'push' data they can only pull so to do what you want you waould have to put that formula in sheet 1 B14 or resort to VB. The correct syntax for B14 would be =IF(A6Sheet2!A14,"",Sheet2!A15) Mike "FoxIII" wrote: I am trying to get a cell to display a message based on the date. I know that if I was in that particular cell, it could be done easily; =IF((A6Sheet2!A14),,Sheet2!A15) where A6 is a given date, Sheet2!A14 is a 'checking' date which changes and Sheet2!A15 is the message I want displayed if FALSE. This is fine, but what I want to do is to get the formula to display my message in another cell. Something along the lines of; =IF((A6Sheet2!A14),,Sheet1!B14=Sheet2!A15) Obviously the above doesn't work though. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
| Conditional format based off of a logical if statement | Excel Discussion (Misc queries) | |||
| IF Statement based on Conditional format | Excel Discussion (Misc queries) | |||
| Change Cell Color Based on IF Statement | Excel Worksheet Functions | |||
| Conditional formatting based on if statement. | Excel Worksheet Functions | |||
Hybrid Mode
