Highlight specific cells based on date in another cell

Question

I am trying to do some conditional formatting on a column in excel. Each cell in the column has different data and I need to highlight certain Cells if the date is today. For instance, column F has dates and column G has a number. When today's date matches any date in column F I need the cell in column F to highlight. I was able to get cells in column F to highlight but not in column G.

Answer 1

Dear respected Jon Tr,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, to highlight cells in both columns based on the date in column F matching today's date, you need to set up conditional formatting separately for each column.

You can set up rules for both columns F and G in Excel.

Highlight Cells in Column F

Select Column F>Conditional Formatting>In the formula box, enter:  

=F1=TODAY()

Select Column G: 

Click on the header of Column G to select the entire column>In the formula box, enter:

 =F1=TODAY()

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 2

Awesome! Thank you!