Software

Ask something
Discussion Locked

Excel date & font question

0 helpful
2 replies

by samtitus

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

2 replies

by dpahari23

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

This discussion is closed to new replies.