Hi All,

I am trying to place a conditional format for all Column Es in my workbook (there are around 50 sheets) such that if they appear in a specified range then they are formatted in all yellow to draw my attention.

My condition is 
Please Login or Register  to view this content.
pretty basic.

Is there a way to copy this and apply it to all the sheets in the workbook? Terribly sorry if this has been asked before, but I searched on this forum and online and couldn't find the answer.

Thank you in advance