Avatar of pdvsa
Flag for United States of America

asked on 

Conditional Formatting - shade cell based on value of another cell


I  need to set up a conditional formatting to shade cells in Col L purple for any corresponding cell in Col E that contains the word "Building".  How can i do that?  

for example
cell E6 contains the word building so shade cell L6 purple.  

thank you
Microsoft ExcelMicrosoft WordMicrosoft Office

Avatar of undefined
Last Comment
Tom Farrar

8/22/2022 - Mon