Cell Formatting

jo - Nov 29, 2017 at 04:54 AM - Latest reply: ac3mark 8362 Posts Monday June 3, 2013Registration dateModeratorStatus December 14, 2017 Last seen
- Dec 1, 2017 at 08:15 PM
Hi

How do I get the cells I am typing in today to turn blue? With historic date remaining black?
See more 

1 reply

Reply to this topic
ac3mark 8362 Posts Monday June 3, 2013Registration dateModeratorStatus December 14, 2017 Last seen - Dec 1, 2017 at 08:15 PM
0
Helpful
SO, every single day, you wish for the sheet to open and evaluate if an entry is in the past? Then take those cells, and change the color to black? Then, upon making a change to the sheet, highlighting the entry as blue?

How familiar are you with the developer tab in excel?
Respond to ac3mark