Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.") |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.") . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.") . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.") . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.") . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A very simple conditional formatting question | Excel Discussion (Misc queries) | |||
SIMPLE VBA MACRO FOR CONDITIONAL FORMATTING | Excel Discussion (Misc queries) | |||
simple conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting, simple question... | Excel Worksheet Functions | |||
Conditional formatting--simple question | Excel Worksheet Functions |