Formatting/conditional formatting?

  • Thread starter Thread starter Elle
  • Start date Start date
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
 
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

Similar Threads

Excel Excel 2013 conditional formatting 1
Conditional Formatting Dates 1
Excel Colour code dates 1
Cinditional formatting question - offsets 5
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional Formatting Problem 2
Access Determine what query to run based on a checkbox 0
Excel Conditional Formatting 1

Back
Top