Hi there,
I have a many range of excel that has many duplicate conditional format.
I would like the user to
- Insert Color into Cell "Z1"
- Select a range of cells
- Run the macro to duplicate rule #3, move this new rule above rule #3, And just change the fill folow as the same as Cell "Z1"
Sample of rule 3 format:
"Use a formula to determine which cells to format" of
=AND(F6="",$B6="K")
with a fill of "blue".
Applies to "=$F$6:$K$15"
Is this possible?
I do not know how to assign color to a variable, how to copy the format conditions of rule #3, as a new one, and change the fill color, and move it above move 3.
Some help would be greatly appreciated.
Cheers!!!
AT
Bookmarks