There's some ambiguity in interpreting the switch scenario you posted
but one of the 2 steps below should deliver what you want
Try it out ..

Either:
Select col A (with A1 active), then apply CF using Formula Is
for the 3 conditions
=AND(COUNT($A1:$B1)=2,$A1<=$B1)
=AND(COUNT($A1:$B1)=2,$A1$B1,$A1<$B1*1.03)
=AND(COUNT($A1:$B1)=2,$A1=$B1*1.03)

Or this:
Select col A (with A1 active), then apply CF using Formula Is
for the 3 conditions
=AND(COUNT($A1:$B1)=2,$B1<=$A1)
=AND(COUNT($A1:$B1)=2,$B1$A1,$B1<$A1*1.03)
=AND(COUNT($A1:$B1)=2,$B1=$A1*1.03)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Roady" wrote:
Yes, this worked until I needed to switch the order so that the column that
is being Conditionally formatted is to the left. Now, when I try to change
the formula to work and hit save/apply, when I go back in there it hasn't
saved any of my adjustments. I think that might be why it's returning a DIV/O
error in blank columns whereas it was not before. Any ideas on how to fix the
formula to work now that the columns are in different order? Thanks, JR