Forum Discussion
Conditional Formatting based on the date of another column
Hi,
I'm trying to conditionally format cells in column A based on their related to cells of the same row in column J.
Essentially if the date in column A is before the day in column J I want ...
Thanks, how do I do that for the whole column.
The values in both columns change with each cell, will I have to conditionally format each cell individually with the two rules?
Hi,
Okay, step by step.
Select you data range in column A and generate new rule
It'll be applied to the selected range, you may correct it if necessary
All cells in that range for which the condition returns TRUE will be highlighted
- I need sort of the same thing, but I have a 'Date Mailed' column and a 'Date Received' column. I need to automatically color the dates in the 'Date Mailed' column whenever the date there is 45+ days older that the corresponding date in the 'Date Received' column. What is the formula for conditional formatting in this scenario? Thanks!
- I can't figure out how to make this it's own post as opposed to a reply. Help!
Go to https://techcommunity.microsoft.com/t5/microsoft-excel/ct-p/Excel_Cat and click 'Start a Discussion'.
Hi Sergei,
Sorry I'm just not with it today - Thanks for all the help!
