I have set up an Excel file to store/analyse some data in my school and want it to do more! I'm using Excel 2016 by the way.
I have columns where I can record a child's targets using for codes B, W, A and GD in 3 different subject areas (therefore 3 cells side by side), these are also conditional formatted to fill with a colour depending on the code that is entered.
I now want the cell to the right of the preceding cells to automatically fill with a colour depending on which codes have been inputted. E.g. if i have entered A, A and A in the 3 preceding cells I want the next cell (to the right) to highlight green. Or it the 3 cells are filled with another combination of codes, e.g. GD, A and GD, the cell to the right will fill green.
Is this kind of thing possible to achieve?
Thank you
Bookmarks