I am creating spreadsheets with multiple tabs for children to work through. To show they have completed each tab, when they have finished the work correctly I am using the following statements:
=IF(A1="5","Well Done!", "")
In this scenario, if the child enters the correct answer of '5', they are told it is correct. I would like to do the same thing with color, where they enter red and are told it is correct. Is this possible?