Conditional Formating Across Whole Sheet

[Lorlai]

I have data in pivot tables. I want to be able to set conditional formatting so that if there is a "!" & cell data, that cell is highlighted. Is there a way to do this for the entire sheet, without having to go cell by cell entering in the conditions?

Thank you!

 

[anandvarma]

watch the following epic video at "EXCELISFUN" You Tube chennal by Mr.Mike Girvin,

http://www.youtube.com/ExcelIsFun#p/search/16/LOaezdoyJDE

This will teach from basic to advance on conditional formatting

try this following formula in conditional formatting

=FIND("!",A1)>=1