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
|