Hi,
I'm trying to create an excel sheet where if I check the tick box to show it's been paid, it would highlight all the cells in the row once ticked; so once that box is checked, everything turns red rather than having to select all the cells and change the colour manually.
Many thanks in...