Forum Discussion

Copper Contributor

Jul 04, 2021

question about conditional formatting

Hello! I am trying to figure out how to create a function or use a tool in excel that allows me to create a result based on a date. I am creating eligibility and ineligibility lists for a job, and it...

excel

office 365

Riny_van_Eekelen

Platinum Contributor

Jul 04, 2021

Katie17626 Use a formula in stead of conditional formatting. See picture below.

Katie17626

Copper Contributor

Jul 11, 2021

Riny_van_Eekelen thank you for the help with this. I’m still confused with how you did the part with the B1 name range cut off. Could you please explain further? I also don’t want to show the formula work on my spreadsheet if possible 🙂

Riny_van_Eekelen
Platinum Contributor
Jul 11, 2021
Katie17626 The formula I provided is a simple IF function. I named one cell "cutoff" and used that name as a reference. I could have used $B$1 also. If a date, in your case, perhaps in column A, is less than or equal to a cutoff date than "Eligible", otherwise "Ineligible".

Not sure what you mean when you say that you "don't want to show the formula work". So you want cells to display "Eligible" or "Ineligible" but not have a formula in these cells. Then you are talking VBA. Not my area of expertise. Sorry!