| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
I've got a column set to change color if it exceeds todays date (late), but I need another one that cancels that if the next column (finished date) is done on time. Right now even if the job is done on time when the due date equals todays date it turns red. -- gargoyle ------------------------------------------------------------------------ gargoyle's Profile: http://www.excelforum.com/member.php...o&userid=37121 View this thread: http://www.excelforum.com/showthread...hreadid=570289 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
your second conditional formatting formula should reinstate the original colour, or you could make your original formula cater for it - give us your formula to look at please -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=570289 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
Cell value is Less than =today() -- gargoyle ------------------------------------------------------------------------ gargoyle's Profile: http://www.excelforum.com/member.php...o&userid=37121 View this thread: http://www.excelforum.com/showthread...hreadid=570289 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting a range with conditional formatting | Excel Worksheet Functions | |||
| conditional formatting glitches | Excel Discussion (Misc queries) | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Linear Mode
