Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

Excel colour help

Copper Contributor

Hi all,


I have a spreadsheet as below (i've blanked out the names in column A relating to staff)


I would like the spreadsheet to be formatted so that if there is any text in rows B9-AD9, B10-AD10 and B11-AD11 then the corresponding cell in row 17 turns orange.


I would also then like it that if we put text in that orange cell, that it goes back white. is that something I can do?


The information going in to the B9-AD9 etc rows will be put in manually. Thank you! 


example of spreadsheet.jpg

1 Reply



sorry just realised the example screen shot doesn't have the column/row details so updated here


example of spreadsheet.jpg