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?

Cell Formatting
Clear only the formatting from the selected cell (leaving the content) - Guide
If cell contains date then return value ✓ - Office Software Forum
Based on the cell values in cells b77 - Excel Forum
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
Count if cell contains number - Excel Forum

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

help me to add particular cells

Highlight cell if another cell contains specific text

How to use conditional format based on text?

If a cell contains any text then add a value

Fill adjacent cell with number from text answer

Similar discussions

Subscribe To Our Newsletter!