Conditional formatting - range of dates
I'm setting up a "tasks" spreadsheet and using condition formatting to
alert missed dates. This is a simple formula, but I'm still struggling. If I use the formula below for past due tasks, all cells appear red except those due today and in the future. How do I write the formula for Condition 3 so I'm not highlighting empty cells? Condition 1: =$D4=TODAY() [green cell] Condition 2: =$B4="Closed" [grey cell] Condition 3: =$D41/27/6 <TODAY() [red cell] |
All times are GMT +1. The time now is 05:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com