Conditional Formatting With New Rule

[RAJESH1960]

Hi, Is it possible to use conditional formatting in a table. If I add new data in the last row, the conditional formatting should apply to that row also.
In this image the row containing the date, the day and month should match with the day and month in cell G1 which is fixed as = today() and format the whole row/rows with a selected color. It works but if I add new data in the next empty cell, it doesn't include that in the condition. So I was wondering if I could convert it into a table.

 

[etaf]

you contradict yourself

If I add new data in the last row, the conditional formatting should apply to that row also.

then

It works but if I add new data in the next empty cell, it doesn't include that in the condition.

you can select the columns
OR
you can select the table and then only apply the format to that range

Jut match day and month - NOT Year
the day and month should match with the day and month in cell G1

Book4
	D	E	F	G
1				9/8/20
2		1/8/30
3		3/8/30
4		5/8/30
5		7/8/30
6		9/8/30
7		11/8/30
8		1/8/31
9		3/8/31
10		5/8/31
11		7/8/31
12		9/8/31
13		11/8/31
14		1/8/32
15		3/8/32
16		5/8/32
17
Sheet1

Cell Formulas
Range	Formula
G1	G1	=TODAY()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E:E	Expression	=AND(MONTH(E1)=MONTH($G$1),DAY(E1)=DAY($G$1))	text	NO

 

[RAJESH1960]

Problem Solved by Kent Paulsson

 

[Joe4]

Problem Solved by Kent Paulsson

Where? Can you provide a link to it?

 

[RAJESH1960]

Where? Can you provide a link to it?

Facebook - Excel for Freelancers Group

 

[Joe4]

Facebook - Excel for Freelancers Group

Did you post the question there, and just find something similar that you were able to use?
If you cannot provide a link, please post the solution for others to see.

 

[RAJESH1960]

Did you post the question there, and just find something similar that you were able to use?
If you cannot provide a link, please post the solution for others to see.

I shared the original file with Kent as requested and he changed the whole picture and completed the file. He deleted all the unwanted columns, changed the formulas too and made it more easy. Sending you both the images old and final ones

 

[Joe4]

Ok. Posting the question to multiple places on the internet is known as "Cross-Posting". While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

Thank you.

 

[RAJESH1960]

Ok. Posting the question to multiple places on the internet is known as "Cross-Posting". While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

Thank you.

Noted Joe4. I hope I haven't broken any rule in asking the same question in another forum.

 

[Joe4]

I hope I haven't broken any rule in asking the same question in another forum.

Like I said (and is mentioned in the Rules), we will allow it if users mention that they are doing so and provide a link.