Hi there,

I have a many range of excel that has many duplicate conditional format.

I would like the user to
  1. Insert Color into Cell "Z1"
  2. Select a range of cells
  3. 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