| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional format to affect a different cell
Maybe Coditional formatting for B1:B5 with this formula:
=AND(NOT(ISBLANK(A1)),ISBLANK(B1)) Select range B1:B5FormatConditional formattingChoose formula as conditionEnter formulaSelect red patternOK Regards, Stefi €župsidedown_pw€ť ezt Ă*rta: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional format to affect a different cell
Thanks so much. I tried guessing but after seeing your formula I was miles
off! Much appreciated :) "Stefi" wrote: Maybe Coditional formatting for B1:B5 with this formula: =AND(NOT(ISBLANK(A1)),ISBLANK(B1)) Select range B1:B5FormatConditional formattingChoose formula as conditionEnter formulaSelect red patternOK Regards, Stefi €župsidedown_pw€ť ezt Ă*rta: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional format to affect a different cell
You are welcome! Thanks for the feedback!
Stefi €župsidedown_pw€ť ezt Ă*rta: Thanks so much. I tried guessing but after seeing your formula I was miles off! Much appreciated :) "Stefi" wrote: Maybe Coditional formatting for B1:B5 with this formula: =AND(NOT(ISBLANK(A1)),ISBLANK(B1)) Select range B1:B5FormatConditional formattingChoose formula as conditionEnter formulaSelect red patternOK Regards, Stefi €župsidedown_pw€ť ezt Ă*rta: 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 |
| Reply |
| 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)
Linear Mode
