How do I write a formula for this:

When 1 is entered into a cell in column E, I want the the cell on the same row in column D to be blank.

And what does col D contain ? Formulas, data ?? A small example sheet ( no pics) will help

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

In the attached, conditional formatting has been applied to D2:D15. It doesn't matter whether the cells in column D contain text, numbers or a formula.
Bear in mind that conditional formatting makes the cell appear blank; it still contains the data that was there when the value in column E is not 1.


The CF formula is
=$E2=1
it's applied to D2:D15
the conditional formatting applied is:
;;;

Attached Files

msofficeforums51100.xlsx (9.2 KB, 3 views)