Hi Can't get round this one!
I have a column of dates which represent when a specific certificate needs renewed, usually 3 years down the line, other than add another column to add on the 3years and compare it with today(), is there a way to create a conditional format that looks at the dates in the column and compares it plus 3years to today()?
Thanks in anticipation of a solution to all the genies out there.
Perhaps using something like that in CF rules
Formula:
Please Login or Register to view this content.
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi Fortis 1991
Tried your formula above, created a list of dates 3 years before today crossing in to less than 3 years today, highlighted the list CF then formula entered but it did not work (List is in (A1 to A10), can't see how this formula is looking at the dates and comparing it to that date plus 3 years!
Hi,
One way
Formula:Please Login or Register to view this content.
Check the boundary condition and change <0 to <=0 as necessary.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard
Thank you that worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks