I am creating an Athletics Spreadsheet and would like some help with conditional formatting.
Each event has a 'Record' and I have done the CF (I think) so that if a record is broken, the new record is highlighted and so is the athletes name.
I have the current record already highlighted in the correct colour HOWEVER, wondering if there is a way to have the current record with no highlight UNTIL it is broken??
Would love some help if I've explained this correctly.
Thanks in advance
I answered trhis in the prevoius thread - please continue there if you are still having issues.
https://www.excelforum.com/excel-for...-formulas.html
Thread closed.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks