Conditional format question

[krisso]

Is it possible to do a conditional format formula that when a percentage in column 1 is greater than the percentage in column 2 that it puts a border line as a divider at the bottom of the section that is above the percentage in column 2 as below?

139.86% 100.00%
131.26% 100.00%
122.96% 100.00%
110.44% 100.00%
107.91% 100.00%
103.77% 100.00%
100.18% 100.00%
===============
96.28% 100.00%
93.63% 100.00%
69.49% 100.00%
69.18% 100.00%
49.34% 100.00%
34.36% 100.00%

Thanks
Chris

 

[Joe4]

Assuming that your data in column A is always sorted in descending order, let's say that your data is in the range A2:B14. Then select the range A2:B14 and enter this Conditional Formatting formula:

=AND($A2>$B2,$A3<$B3)

and choose your desired border option.

 

[krisso]

Thank you. Worked perfectly

 

[Joe4]

You are welcome!