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

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

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

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