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
Related:
- Conditional Formatting Question
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Yahoo mail forgot password and security question - Guide
- Formatting usb mac - Guide
- After formatting computer what's next ✓ - Laptop Forum
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