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
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
D Apps General Discussion 3
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

TRENDING THREADS