Help needed in Conditional Formatting please

DebbieK · Mar 30th, 2004, 10:41 AM

Hi

Can someone help me please, im pretty new to Excel and am having my first attempt at conditional formatting. I have created a spread sheet which has a column of dates.

I need the sheet to highlight todays date in red so I have:

=INT(G5)=TODAY()

I then need it to flag up dates in yellow up to 31 days ahead of todays date:

=AND(INT(G5)>TODAY(),(INT(G5)-TODAY())<31)

My problem is that I also need it to flag up dates prior to today, i.e. overdue dates in another colour. So what test do I need to put in for condition 3. Any help gratefully received

Mar 30th, 2004, 10:41 AM	#1
DebbieK Join Date: Mar 2004 Posts: 2	Help needed in Conditional Formatting please Hi Can someone help me please, im pretty new to Excel and am having my first attempt at conditional formatting. I have created a spread sheet which has a column of dates. I need the sheet to highlight todays date in red so I have: =INT(G5)=TODAY() I then need it to flag up dates in yellow up to 31 days ahead of todays date: =AND(INT(G5)>TODAY(),(INT(G5)-TODAY())<31) My problem is that I also need it to flag up dates prior to today, i.e. overdue dates in another colour. So what test do I need to put in for condition 3. Any help gratefully received

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode