Color Change in a timeline

[Manolocs]

Hi, ROW 3 has dates from January 1st (C3) to December 31st (NC3).
I want the todays date Cell change color, but all dates before maintain the same color, like a timeline add one cell everyday and maintain past dates with color and futures dates blank.
-Is there a way to build this with formulas? Conditional Format?
Thanks in advance.

 

[seguin85]

Highlight C3:NC3, click on conditional formatting. Then "New Rule", "Format only cells that contain". From the drop down box under format only cells with, change "Cell Value" to "Dates Occurring" and change "Yesterday" to "Today".

Click on the "Format" button and change to your desired format.

 

[Manolocs]

@seguin85 This works very well, but only the todays date is colored, is there a way to have all dates until today date colored?

 

[seguin85]

Oh I misread, I thought you only wanted today's date coloured.

Yes, go to conditional formatting, manage rules, click on the rule you made, hit the button edit rule.

Under select a rule type, click format only cell that contain, then from drop down menu choose cell value, less than or equal to, then in the box enter "=TODAY()"

 

[Manolocs]

@seguin85 works great exactly what I needed I have another question related to this but I will make a new question in this forum, maybe if you have time.....