Is it possible to copy conditional formatting (with multiple formulas) that depe

Question

Is it possible to copy conditional formatting (with multiple formulas) that depends on a condition in one cell to a range of cells (whose conditions would come from a range of cells)?

Sorry for the long question, but since I couldn't quite find my answer in the questions I've seen about copying conditional formatting, I thought I make it as clear as possible.

Here's my case:

I have conditional formatting (CF; 3 formulas) applied to one cell H3 based on I3:

=$I$3=0% applied to =$H$3 (no color)

=SI($I$3<>0%;$I$3<>100%) applied to =$H$3 (yellow)

=$I$3=100% applied to =$H$3 (green)

But I want H4, H5 & H6 to also have the same CF (all 3 formulas) based on, I4, I5, & I6

If tried the copy CF examples I've seen on the web,but none tell me how to copy the CF to a range of cells (H4:H6 in this example) based on the selection made in another range of cells (I4:16).

Thanks in advance for a quick resolution (if this is possible) Also, I'm in Excel 2010.

Also as a side question,is there anyway to insert images or use Excel inhouse CF symbols in place of my colors as the formatting??

Thanks !!

Explanation / Answer

Hi..

Ok, after much, much seaching I found my own answer from Mr. Excel (Thank you sir!!!) Apparently you have to remove the "$" in front of the "3" in my condition formula:

=$I3=0% applied to =$H$3 (no color)

=SI($I3<>0%;$I3<>100%) applied to =$H$3 (yellow)

=$I3=100% applied to =$H$3 (green)

VS

=$I$3=0% applied to =$H$3 (no color)

=SI($I$3<>0%;$I$3<>100%) applied to =$H$3 (yellow)

=$I$3=100% applied to =$H$3 (green

And simply select H3 and drag downward to copy the CF to H4:H6 and voil

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.