| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell formula help?
Hi All,
I've got the following formula in cells on a worksheet... =IF($E4=AU2,"PO",IF(($E4+18)=AU2,"IC","")) Obviously this gives me "PO" and "IC" 18 cells apart when E4=AU2. What I would now like to do is somehow colour the cells between these 2 values. Does anybody have any suggestions? TIA BC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
![Brad[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
