Forum Discussion
Conditional Formatting
Hi, I have changed it so that ALL records less than today (+ optional n) shows as RED.
Kind regards
I was hoping you could assist me with a similar problem? My spread sheet has membership dates in one column and expiry dates in the adjoining, I had it set up so if the exoiry dates were exceeded, the cells high lighted with a red fill. This no longer seems to be working, could you help me please? Nauthstar
Hi johnc47
I don't think there was anything really wrong with your spreadsheet. The conditional formatting was not showing because you had updated the memberships with new dates for this year.
I have however made a few adjustments. I've made your list a table so you won't need to update formulas when you add a new person to the bottom - all the conditional formatting will also coy down.
I've modified the print so that the header appears on every printed page and I've also added a column which tells you the Student's age.
At the top I've also included a couple of equations to tell you how many students you have and their average age. These rows along with the bubbles can be deleted without it affecting your print range.
Hope this helps and good luck with the classes.
Kind regards
Nauthstar