I am using conditional formatting to highlight cells
by using the following formula, but doesn't work,
what am I missing?, please help.
cell A1 has a date
cell A2 =EDATE(A1,1)
I want to highlight cells A1 and A2
=AND($D$13>TODAY(),TODAY()<5)
I want cells to be highlighted between today & 5 days only.
sorry, to reply to my own post !
I got it working with this formula
=AND(B1>=TODAY(),B1<=TODAY()+5)
cell A1 has a date
cell B1 =EDATE(A1,1)
the only problem now is that the cell that has
the EDATE doesn't get highlighted
Hi mikehk,
This formula will not highlight in B1 because B1 will be outside of the 'today' and '5 days' range. If you want B1 to highlight whenever A1 is between today and 5 days from today, use this conditional format formula for A1 and copy across to B1:
The '$' sign ensures that the formula still references A1.
Please Login or Register to view this content.
Did I help? Click *- add to my rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks