How to apply Conditional Formatting for Multiple Columns

[mikeynavy1976]

I'm struggling to figure how to use conditional formatting for more than one column. I have one column of data that I want to compare to adjacent data in another column. If it is less than that it's counterpart I want it to be red, and if it is greater, green. I can only get it to work if I enter the rule one by one for each "cell." How do I get it so that I can select all the cells with data, select the next column with the data I want compared (row by row) and have the conditional formatting applied?

 

[rahul nagar]

Hi mikeynavy1976,

If you want 3 conditional formatting then you can use conditional formatting option from Format >> conditional formatting >> Click on Add tab.
And if you want more then 3 conditional formatting the you need VBA formula.
In that case please attach sample file for more details.

Regards,
Rahul Nagar