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

@Paskylou 

 

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

 

example of spreadsheet.jpg