I can add a sum colour cell formula and i can add a button however i can not get them to work together.

or alternately can you enter a formula to colour a different cell based on whats entered across other cells.


for example (if sheet1A2 = data!A1:A10 then colour F2 red) is something like that possible??