Looking to implement Conditional Formatting w/o using 'Helper' columns

Question

Hello All,

I am looking to conditionally format cells that have calendar dates within them. The book that I have attached has 2 sheets. The first sheet titled 'Project' is the one that I need to have setup with the conditional formatting.

On the second sheet titled 'Practice', I included helper columns. Within those columns I used the 'TODAY' function to identify the difference between the present calendar date and the dates that are in question, so that i could conditionally format the necessary cells.

The reason why I did it in this manner is because I don't know how to use >only< the columns that are already present on the original 'Project' sheet. I want to construct the 'Project' sheet to get the conditional formatting results within the designated columns as opposed to plugging in additional columns as I did on the 'Practice' sheet. (If that is even possible)

So in other words - I wish to format the designated columns in the same manner as I have done with the helper columns that I added.

Below is what I am trying to accomplish with the 'Project' sheet.

Column A
– For dates that are 60 days and greater, past the current calendar date, I need to have those particular cells highlighted (Black fill and a Red font, Bold)

Column E
A) For dates that are 15 days out, all the way down to the current calendar date, those cells need to be formatted as (Yellow fill and a Red font)
B) For dates that have passed the current calendar date, they should be (Black fill and a Red font, Bold)

Column G
A) Dates that fall between 30 days in the future, all the way down to the present calendar date, need a change to (Yellow fill and a Red font)
B) For dates that have passed the current calendar date need to change to (Black fill and a Red font, Bold)

Column I
– Dates that have reached 30 days past the current calendar date, should have (Black fill and a Red font, Bold)

Can someone show me how to get this accomplished? If it is indeed possible to do w/o helper columns.

Thanx!

WB

Answer 1

See https://www.dropbox.com/scl/fi/eiey3drxz3w7qd1ycuv6g/Need-to-highlight-certain-dates.xlsx?rlkey=p8jzn9wwpp73g1ishhsfddyj7&dl=1

Answer 2

Yes Sir! This is precisely what I needed.

I see what you did here and I will definitely keep this logged for future reference just in case I need to do this again and unable to remember how you setup the formula.

Much Thanks!

WB