Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that contains 3 columns. Date of Birth, Retirement
Date, Waiver Date. I have created a formula to automatically calculate the
retirement date and waiver date based on the date of birth.

Does anyone know how I can set up a conditionl format to highlight the cells
of the retirement date and waiver date once the current date (Today's Date)
is either equal or greater than the date of the retirement date or waiver
date??

Thanks.
 
Assume retirement date in B2 and waiver date in C2

Select B2:Cxx where xx is end of data in column C.

Format>CF>Formula is:

=B2<=today()

Note:Excel may try to assist by adding $ signs as in $B$2

Delete them.


Gord Dibben MS Excel MVP
 

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

How do i set up a sheet to count the years to retirement? 1
Calculating age from date of birth and ignoring if blank 5
conditional formatting or VB 3
Comparison of columns using Conditional Formatting 3
calculate which cells arrives first 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Financial Time Value of Money calculations 5
Conditional Formatting Date Range 2

Back
Top