Formatting/conditional formatting?

E

Elle

Hello,

I have a deadline date in one cell and a planned/rescheduled date in
another. If that is past the deadline date i want it to automatically
highlight it red?

Also I want a new cell to be inserted when the one above is filled...is this
possible?

Thank you
 
A

Atishoo

assuming that your rescheduled date is in A! and deadline date is B1 then A1
conditional format should be

cell value is greater than=$b$1

then set the pattern as red
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top