Cond Formatting Problem
Hi
I have an example spreadsheet attached. its a teachers markbook.
When I add further colums of grades to be input the colour coding does not copy and keep the designed formatting from the original.
Can you help please?
Crakkers
| Attachment | Size |
|---|---|
| CF Grades Example 2.xlsx | 9.44 KB |
Extend your conditional formating
At present you have added conditional formatting for cells C3:C24, highlight the area you wish to include conditional formatting e.g. C3:M24 and use the same rules, however remove the $ symbol from $C3 to be just C3 as follows:
=MATCH(C3,Grade,0)-MATCH($B3,Grade,0)
Regards
Mark