Cell formatting based on date
I want to change the colout of a cell once the current date has passed
|
Cell formatting based on date
On Thu, 28 Jul 2005 03:23:03 -0700, "blackadder"
wrote: I want to change the colout of a cell once the current date has passed Select your cell. From the top menu bar: Format/Conditional Formatting Cell Value Is less than =TODAY() Select Format and decide on your formatting. --ron |
All times are GMT +1. The time now is 09:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com