Creating a Formula to Format Column automatically?

[bludovico]

Can I record it as a macro or anything like that? I have to run it o
five sheets. I've tried to conditional formatting, and it works only o
one cell, unless I'm doing it wrong

 

[Guest]

not sure what you are trying to do but conditional
formating can be coped and pasted. you have also
conditional format an entire column/row by selected the
entire column.
if conditional formating is what you are after, try that.