Is there a Macro I can write for Conditonal Formating?

[Snaybot]

I want to write a macro for conditonal formatting

I want to highlight any cell containing the word "If "

[stnkynts]

I am assuming by the way you phrased your question that you are looking to use a macro instead of conditional formating to highlight the cell. I will also assume that you want to search the whole worksheet rather than just a single column or row and that you want to search values not inside a formula. Try this:

Please Login or Register  to view this content.

[Snaybot]

Awesome Man!


Is there any way to use the active sheet instead of Sheet 1?

Also is there even an option for active Workbook?


Also what is the coloro

[Snaybot]

I got it thanks!