Highlight a column if it is today's date

[falcios]

I need to highlight a column with the condition being today's date.
I've checked this forum and YouTube for suggestions.

This should be a simple formula but the formulas I'm using are not working.

I've tried different formulas

=A$1=TODAY()

IF(A$1=TODAY(),TRUE,FALSE)

In the current worksheet, the current date is on F1.

What formula can I use to highlight the column if it is today's date?

Thanks in advance.

 

[6StringJazzer]

Highlight the column if what is today's date? The value in row 1 of that column? And what is in that cell? If you also have a time, your formula won't work. It would be so helpful if you could show us some of your data so we can visualize what you want to do.

Without more information my best guess would be:

=INT(A$1)=TODAY()

(You don't have to use IF(condition, TRUE, FALSE) because the condition itself will be TRUE or FALSE.)

 

[kvsrinivasamurthy]

Pl do not use Entire column.
Say range is A1:G100000. Select the range. Formula for CF

=COUNTIF(A$1:A$100000,TODAY())>0

 

[falcios]

=COUNTIF(A$1:A$100000,TODAY())>0

Thanks kvsrinivasamurthy. It worked like a charm.

 

[falcios]

The formula works great; however it only works on one worksheet. Is there a way to copy this formula to all sheets - 52 for weeks of the year?

Thanks in advance.