View Single Post
 
Old 02-11-2019, 07:03 AM
Oluagbe1 Oluagbe1 is offline Windows 10 Office 2019
Novice
 
Join Date: Feb 2019
Posts: 8
Oluagbe1 is on a distinguished road
Default

Quote:
Originally Posted by Marcia View Post
I'm sorry NBVC, I missed reading your second post. At any rate, Oluagbe, I removed the name in the criteria but it would be best if you add the registration number in the criteria. You change "$B:$B" to "$C:$C" (The "C" is the column number of the registration numbers in the year sheets) and the C2 to E2. C2 is the cell address of the name in the cummulative sheet while E2 is the registration number.


I've placed the conditional formatting in columns D and E. Try copying a number and pasting below it, the duplicate number should be colored.

Thank you very much.

I was thinking what if we use just one criteria which is more stable that is the oracle numbers?

This should even populate more cells with the actual scores from the yearly sheets into the cumulative sheet.
Reply With Quote