General discussion

Locked

Excel date & font question

By samtitus ·
I want to do the following:
I enter a date in col A1 and Each time I open a worksheet the current date in colB1 is compare and when the date has lapse I want the date in col A1 to flash in red or any other column. Can this be done?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by samtitus In reply to Excel date & font questio ...

Point value changed by question poster.

Collapse -

by dpahari23 In reply to Excel date & font questio ...

select A1
go to format
conditional formating (pop up window will be displayed)
by default'cell value is' is displayed. if not select from the drop down list
From next drop down list, select 'greater than or equal to'
On the text box beside it, enter '=today()'
Underneath, click on the 'format'button and select the color of your choice.
when ever the condition on the column A1 is equal to or grater than today, it will be displayed as the color of your choice.

Hope this helps.

Good Luck

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums