Conditioning Formatting Question - linked to other cells

  • Thread starter Thread starter MrMerton
  • Start date Start date
M

MrMerton

Dear All,

Could anyone help me with the following question:

I have a spreadsheet with a column of cells that are coloured (colored
in purple whilst a project is incomplete but which are then coloure
white again when the project is finished. I have another column i
which the completion date is written (once it is finished). Is there
way I can use conditional formatting to have the first column becom
uncoloured conditional on the other cells? Thus, I want cell B1 to b
white IFF cell D1 is not empty.

I am using Excel 97 (for my sins).

Any help very gratefully received!

Many thanks!

Wil
 
Hi MrMerton!

Use the Is Formula option in conditional formatting [first drop down].

Eg.
=ISBLANK(D1)

In your formatting options in conditional formatting you'll note that
you have the option to select no color which would mean that the cell
would not "take" the normal background color that you have set.
 
Back
Top