Conditional Formatting macro: simple, but doesn't work
 

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.")

Conditional Formatting macro: simple, but doesn't work
 

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.



"JP" wrote in message
...
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.")

Conditional Formatting macro: simple, but doesn't work
 

Sorry. should have been if A1 < a2 then it will be red.


"JP" wrote in message
...
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.")

Conditional Formatting macro: simple, but doesn't work
 

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."

"JLGWhiz" wrote:

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.



"JP" wrote in message
...
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.")


.

Conditional Formatting macro: simple, but doesn't work
 

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.


"JLGWhiz" wrote:

Sorry. should have been if A1 < a2 then it will be red.


"JP" wrote in message
...
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.")


.

Conditional Formatting macro: simple, but doesn't work
 

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.


"JP" wrote in message
...
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.


"JLGWhiz" wrote:

Sorry. should have been if A1 < a2 then it will be red.


"JP" wrote in message
...
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.")


.

Conditional Formatting macro: simple, but doesn't work
 

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

"JLGWhiz" wrote:

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.


"JP" wrote in message
...
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.


"JLGWhiz" wrote:

Sorry. should have been if A1 < a2 then it will be red.


"JP" wrote in message
...
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.")


.



.