How to apply Conditional Formatting for Multiple Columns

mikeynavy1976

Distinguished
Feb 14, 2007
90
0
18,590
2
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

Distinguished
Dec 24, 2010
3
0
18,510
0
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


 
Thread starter Similar threads Forum Replies Date
Glissy Apps General Discussion 0
B Apps General Discussion 2
H Apps General Discussion 2
A Apps General Discussion 2
P Apps General Discussion 1
C Apps General Discussion 1
B Apps General Discussion 8
V Apps General Discussion 1
L Apps General Discussion 3
S Apps General Discussion 2
B Apps General Discussion 2
M Apps General Discussion 4
Z Apps General Discussion 4
P Apps General Discussion 1
W Apps General Discussion 1
E Apps General Discussion 4
L Apps General Discussion 2
M Apps General Discussion 7
C Apps General Discussion 1
W Apps General Discussion 4

ASK THE COMMUNITY