Hi,
Being new to EXCEL I get confused with formulas, and which ones to use.
I have a golf scoring spread sheet and was wondering if EXCEL can highlight certain scores if certain conditions were met & how do I do it?
First of all, the person's class could change because of their scores going either higher or lower.
Column A has different "Class" of players from A-E
Row 1 has the par for each hole
If column A = A, then highlight cells with scores that are 1 above par or greater
If column A = B, then highlight cells with scores that are 2 above par or greater
If column A = D, then highlight cells with scores that are 3 above par or greater
If column A = E, then highlight cells with scores that are twice the value of par or greater
If column A = C, then highlight cells with scores =>+2 on par 5, with scores =>+3 on par 4 & with scores =>+1
Bookmarks