Could anyone please advise on conditional formatting?

I'm trying to use a formula to have say cell a1 to change colour IF cell d1 has

I've been trying conditional formatting in cell a1 as - If(d1="",TRUE,FALSE) but no change happens with input to cell d1.

Any help would be greatly appreciated.

I'm trying to use a formula to have say cell a1 to change colour IF cell d1 has

**input?***any*I've been trying conditional formatting in cell a1 as - If(d1="",TRUE,FALSE) but no change happens with input to cell d1.

Any help would be greatly appreciated.

Last edited: