Forum Discussion

Sam Collins's avatar
Sam Collins
Copper Contributor
Oct 10, 2018
Solved

Conditional format a cell that corresponds to todays date

Hi all, I have a table of sorts with months running across the top and then days running down the left. The months are the first day of each month but formatted to show the just month in "mmm" forma...
Conditional Formatting
excel
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Oct 10, 2018

    Hi Sam,

     

    I've updated the workbook you attached with the below conditional formatting formula to highlight today's date.

    =CELL("address",D4)=ADDRESS(DAY(TODAY())+3,CHOOSE(IF(YEAR(TODAY())=2018,1,2),MONTH(TODAY()),MONTH(TODAY())+12),1)

     

    But, please be careful not to change the current layout of the table because the formula depends on it.

     

    Regards,

    Haytham

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 13, 2018

Hi Haytham Amairah,

 

You are right, thank you,

=(D$4+ROW()-ROW(D$4)-1)=TODAY()

 

For the maintenance purposes I'd prefer to keep reference on the row instead of number. If one day you decide to add one more row on the top of the sheet the formula will be adjusted automatically. Otherwise you shall to do that manually.

Resources