Forum Discussion
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...
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 🙂
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!