| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format to affect a different cell
Hi,
I need to make a cell change colour when anything is written in different cell. e.g. when a date is entered into A1:A5, B1:B5 highlight in red. When the red boxes in B1:B5 are written in to say they have been actioned I need the cell to return to white. Can anyone help me? Thanks Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format - another cell | Excel Worksheet Functions | |||
| conditional format cell | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| conditional formats affect other cells | Excel Discussion (Misc queries) | |||
| Can a conditional formatting result affect another cell or cells | Excel Worksheet Functions | |||
![upsidedown_pw[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
