Formating cells when today() in Schedule

[Wilco()]

I have a roster, where I want to highlight a column if the date in row "4" is today. For example, if today is 20 april 2016 then I want to highlight U4:U15.

How can I do that?

And then... Is this going to be 1 rule? Or for each column a new rule? I really hope it is possible with the minimum amount of rules. As you can imagine, the full roster include a full year (365 days).

 

[Khalid NGO]

Hi,

If you want to highlight column U only when there is today's date in row # 4, select your range (U4:U15) and use this in CF formula:
=TODAY()=U$4

If you want to highlight more columns, just extend the applies to range for example U4:AF15.

Regards,

 

[Wilco()]

thanks. I have tried your solution. Somehow, nothing happens.

I select the cells I want to format: U4:u15
I click on conditional formatting -> New Rule -> "Use formula to determine which cells to format".
In the field "format values where this formula is true" I enter:

I want to highlight each day a different column. Today it is column U tomorrow it should highlight column V. The day after tomorrow colum W etc. etc.

 

[Vishal Srivastava]

thanks. I have tried your solution. Somehow, nothing happens.

I select the cells I want to format: U4:u15
I click on conditional formatting -> New Rule -> "Use formula to determine which cells to format".
In the field "format values where this formula is true" I enter:

I want to highlight each day a different column. Today it is column U tomorrow it should highlight column V. The day after tomorrow colum W etc. etc.

You have to select entire range e.g: C4 to AF15

and then go to conditional formatting and create new rule using following formula:
=C$4=TODAY()

select format of your choice - > OK.

Thats it.

Thanks & Regards,
CMA Vishal Srivastava

 

[Khalid NGO]

thanks. I have tried your solution. Somehow, nothing happens.

Hi,
The cell U4 does not contains today's date, therefore it is not getting highlighted.

I want to highlight each day a different column. Today it is column U tomorrow it should highlight column V. The day after tomorrow colum W etc. etc.

I have manually entered today's date i.e. 20-Apr-2016 in U4, and extended the CF range, see the attached.

Regards,