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
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Yahoo mail forgot password and security question - Guide
- This question is locked and replying has been disabled. - Facebook Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel 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