conditional format to affect a different cell

[upsidedown_pw]

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

 

[Stefi]

Maybe Coditional formatting for B1:B5 with this formula:
=AND(NOT(ISBLANK(A1)),ISBLANK(B1))
Select range B1:B5>Format>Conditional formatting>Choose formula as
condition>Enter formula>Select red pattern>OK

Regards,
Stefi

„upsidedown_pw†ezt írta:

 

[upsidedown_pw]

Thanks so much. I tried guessing but after seeing your formula I was miles
off! Much appreciated

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„upsidedown_pw†ezt írta: