Hi all,
Is there any way I can use conditional formatting so that when a user fills in the first box with a title that the spreadsheet then converts the following 8 boxes in that row to blue with a border around it?
Currently I have a conditional formating in that if the box is not blank to colour blue and put on a border but if they don't fill in all areas then the box stays white making the spreadsheet look odd.
Bookmarks