formatting cell that contain

[ttowncorp]

is there a faster way besides using conditional formatting to color specific columns like in VBA. I want to have the cells for example in C4-C53 g4-g53 k4-k53 etc etc to change colors if they are less than or equal to 1. i have 40+ columns to do so as you can see doing it in conditional formatting will take time.

 

[Fluff]

Just select the columns & then set the CF rule
=C4<=1

 

[ttowncorp]

thanks that worked.

 

[Fluff]

You're welcome & thanks for the feedback