I'm at the end of my rope on this one. I've looked, and I can't find anyone else having this issue.
I've got 19 Columns, A:S. At the top, there are a few merged cells that get in the way of just Conditional Formatting the entire columns. There's nothing I can do about that. My problem is, the Conditional Formatting only works on most of the cells in the range, and then, it changes every time I click "OK" to create a New Rule.
If the cells contain anything at all, I need to highlight all of the cells in from A3:Dwherever_they_ stop, in Color1, E3:Fwherever_they_ stop in Color2, G3:Jwherever_they_ stop in Color3, K3:Lwherever_they_ stop in Color4, M3:Nwherever_they_ stop in Color2, O3:Rwherever_they_ stop in Color3, and S3:Swherever_they_ stop in Color5.
There are not Rules previously applied to the workbook, anywhere, and there are no strange formats applied anywhere. The information is being Copy/Paste_Values from another workbook through a Macro. I can't paint in the formula manually, as this needs to be part of the same macro, so others can't (HA! Right!) screw it up later. The only formatting is Row/Column sizes. Every time I input my formula for the Conditional Formatting, [Conditional Formatting>New Rule>=A1<>"" > Format>Chose_Colors/Border>OK>OK], It changes from A1 to A3 or A5. When I go back in and change the range for it to be applied to from $A$1 to $A$3:$A$1000, it changes the Formula value to random places on the sheet...
I'm so frustrated I want to bite something!
Can someone please help me get this figured out so I don't start considering fire as an option!
I've got 19 Columns, A:S. At the top, there are a few merged cells that get in the way of just Conditional Formatting the entire columns. There's nothing I can do about that. My problem is, the Conditional Formatting only works on most of the cells in the range, and then, it changes every time I click "OK" to create a New Rule.
If the cells contain anything at all, I need to highlight all of the cells in from A3:Dwherever_they_ stop, in Color1, E3:Fwherever_they_ stop in Color2, G3:Jwherever_they_ stop in Color3, K3:Lwherever_they_ stop in Color4, M3:Nwherever_they_ stop in Color2, O3:Rwherever_they_ stop in Color3, and S3:Swherever_they_ stop in Color5.
There are not Rules previously applied to the workbook, anywhere, and there are no strange formats applied anywhere. The information is being Copy/Paste_Values from another workbook through a Macro. I can't paint in the formula manually, as this needs to be part of the same macro, so others can't (HA! Right!) screw it up later. The only formatting is Row/Column sizes. Every time I input my formula for the Conditional Formatting, [Conditional Formatting>New Rule>=A1<>"" > Format>Chose_Colors/Border>OK>OK], It changes from A1 to A3 or A5. When I go back in and change the range for it to be applied to from $A$1 to $A$3:$A$1000, it changes the Formula value to random places on the sheet...
I'm so frustrated I want to bite something!
Can someone please help me get this figured out so I don't start considering fire as an option!
