Thread
:
conditional formating on dates
View Single Post
#
6
Posted to microsoft.public.excel.misc
DILipandey
external usenet poster
Posts: 70
conditional formating on dates
Hi,
If you have the dates in column A starting with row1, then you can use
following logic in conditional formatting:-
=IF(A1-NOW()<=30,"True","False")
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
New Delhi, India
"Margotbf" wrote:
Hello,
I have to track expiry dates in a datasheet. Actually, I'd like the expiry
date field to change color 30 days prior to the expiry date written in the
field. Let's say the expiry date is oct 24 2008, I want the field to change
color on sept 25 2008. The date format chosen is 24-oct-08, does it matter?
Thanks!
--
Margot
Reply With Quote
DILipandey
View Public Profile
Find all posts by DILipandey