Conditional Formatting macro: simple, but doesn't work

J

JP

Conditional Formatting macro: simple, but doesn't work. Using Excel 2007
with Windows 7.

Enter the number 1 in cell A1 and the number 2 in cell B1.

Start the macro recorder.
Select A1:B1.
Click Conditional Formatting, New Rule, Use a formula.
Enter: =$a1<>$a2, Format, Border, select a continuous bottom border, OK, OK.
Select cell B1 (only).
Click Conditional Formatting, New Rule, Use a formula.
Enter: =B1<>C1, Format, Font, Color, select red, OK, OK.
Stop the macro recorder.

Everything looks perfect with a line under cells A1:B1 and red font in cell
B1 (only).

Click Conditional Formatting, Clear Rules, Clear Rules from Entire Sheet.
Run the macro.
It does not implement correctly.
The incorrect result is a red font in both cells A1 and B1 rather than just
cell B1.
The text of the macro looks correct yet it insists on applying the font
color to both cells.

I tried modifying the macro, used cell ranges rather than "Selection," and
rearranged the sequence--all to no avail.

(Interestingly, if you reverse the order by first applying the conditional
font color to B1 prior to the conditional bottom border being applied to
A1:B1, the macro returns "Run-time error '1004': Unable to set the LineStyle
property of the Border class.")
 
J

JLGWhiz

If a <> b then it will be red. The only way it will not be red is if a = b.
You did not specify what the cell contents were when you ran the macro.
 
J

JP

The cell contents were in fact stated in the original post as, "Enter the
number 1 in cell A1 and the number 2 in cell B1."
 
J

JP

As previously stated, the formula that needs to be entered is: =$a1<>$a2,
not "A1 <> a2."
If the steps in the original post are followed precisely you'll see what I
mean.
Thanks for replying.
 
J

JLGWhiz

I did try it after I had posted the reply and it looks like it does not like
the overlap on the first condition for some reason. I have not spent a lot
of time on Conditional Format so I won't be any help to you on this one.
 
J

JP

Thanks, JLG, for trying. Your efforts are appreciated. This one may have to
remain unresolved.
Best regards,
JP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top