Conditional Formatting Question
Closed
chopper1987
-
Oct 11, 2010 at 02:44 AM
nephilim3uk Posts 11 Registration date Monday August 9, 2010 Status Member Last seen October 27, 2010 - Oct 11, 2010 at 04:56 AM
nephilim3uk Posts 11 Registration date Monday August 9, 2010 Status Member Last seen October 27, 2010 - Oct 11, 2010 at 04:56 AM
Hello,
I am having problems with conditional formatting on Microsoft Excel 2003. The Excel file I am trying to format is basically a long list of tasks that I need to do in work and then 2 columns; 1 with date due and 1 with date to start. I want to highlight any dates that are before today's date red, any with todays date orange and any date after today's date green. I'd like any blank cells to also remain blank. Can anyone help with this please, I've tried a few formulas after reading up on a few forums but I'm still having problems.
Thanks in advance,
Craig
I am having problems with conditional formatting on Microsoft Excel 2003. The Excel file I am trying to format is basically a long list of tasks that I need to do in work and then 2 columns; 1 with date due and 1 with date to start. I want to highlight any dates that are before today's date red, any with todays date orange and any date after today's date green. I'd like any blank cells to also remain blank. Can anyone help with this please, I've tried a few formulas after reading up on a few forums but I'm still having problems.
Thanks in advance,
Craig
Related:
- Conditional Formatting Question
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- How can i recover my yahoo account with security question - Guide
- Google recovery password security question - Guide
- Formatting usb mac - Guide
1 response
nephilim3uk
Posts
11
Registration date
Monday August 9, 2010
Status
Member
Last seen
October 27, 2010
1
Oct 11, 2010 at 04:56 AM
Oct 11, 2010 at 04:56 AM
Hi
You could use conditional formatting off the format menu.
Set the 3 conditions to be;
Condition 1 = Cell Value is, equal to, =TODAY() (then format orange background)
Condition 2 = Cell Value is, less than, =TODAY() (then format red background)
Condition 3 = Cell Value is, greater than, =TODAY() (then format green background)
hope that helps
Richard
You could use conditional formatting off the format menu.
Set the 3 conditions to be;
Condition 1 = Cell Value is, equal to, =TODAY() (then format orange background)
Condition 2 = Cell Value is, less than, =TODAY() (then format red background)
Condition 3 = Cell Value is, greater than, =TODAY() (then format green background)
hope that helps
Richard