Solved excel if today = a specific day in month

October 28, 2011 at 10:26:05
Specs: Windows Vista
I need to format a cell based on a specific day in the month i.e. every 27th of each month the cell highlights.

I've tried TODAY() function without success.

Help Please!


See More: excel if today = a specific day in month

Report •


#1
October 28, 2011 at 10:36:40
You haven't provided a lot of detail, so it's kind of hard to be very specific.

In general, if you had a cell that contained a date, e.g. A1, you would Conditionally Format the cell with this Rule:

=DAY(A1) = 27

Whenever that Rule was TRUE the format that you chose would be applied

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
October 28, 2011 at 14:00:45
Sorry. Let me try to make it clearer.
Todays date, via TODAY(), is shown in A1. I need to format J15 to display specific text on the 27th of each month.

Report •

#3
October 28, 2011 at 15:34:37
✔ Best Answer
Well, your use of the word "format" is still confusing.

You don't need to "format" J15 to display text, you can use an IF function:

=IF(DAY(A1) = 27, "specific text", "")

J15 will display an empty cell except in the 27th of each month.

Using an IF function is not considered "formatting" the cell.

If you really want to format J15 to display the text on the 27th, then you could use Conditional Formatting in this manner:

1 - Put your "specific text" in J15.
2 - Format the cell such that the font color matches the background color.
3 - Use the Conditional Formatting rule I offered above (=DAY(A1) = 27) and set the Font Color (within Conditional Formatting) to be something other than the background color of the cell.

On the 27th of each month the Font Color of J15 will change to the color you chose and the text will appear. On every other day, the Font Color will match the background color of the cell and won't be seen.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
October 29, 2011 at 03:18:03
That's great, Thanks!

I had tried =IF but using TODAY() which was obviously not correct.

Thanks again.


Report •


Ask Question