highlight dates when it arrives on a spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to develop a spreadsheet that projects dates due and highlights
that date when it arrives (maybe in another color).
 
stephanie said:
I'm trying to develop a spreadsheet that projects dates due and
highlights that date when it arrives (maybe in another color).
Click to expand...

Hi Stepahnie,

select the range with your dates, then from menu Format, Conditional
Formatting, under Condition 1 select Formula is than in the text box type a
formula like this:

=A2=TODAY()

than choose the format you prefer.

I used A2 because I assume that your dates are in column A starting from A2,
so you have to change.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel Excel due and overdue date colours 2
Highlight Highest Amount 2
conditional formatting highlight dates 90 days or less 7
Reserved dates 3
How do I get a cell to highlight when a deadline date approaching 4
What is formula to have an upcoming date change color? 8
conditional formating: ifs and highlighting rows 8

Back
Top