Previous Topic Next Topic

Cell Formatting

Closed
jo - Nov 29, 2017 at 04:54 AM
 Blocked Profile - 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?

1 response

Answer 1 / 1
Blocked Profile
Dec 1, 2017 at 08:15 PM
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?

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional formatting several cells risk register
oyvinols -
fdibbins -

1 response
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response