Dinamic Conditional Formatting

Dear Excel Experts

Is it possible to use dynamic conditional formatting?
what i mean :

\1

if column Color, I change the content Green to Red, then columns with green shadowed change to red accordingly.

thanks

Originally Posted by yates1_99

Attachment 415190Conditional Formatting
New Rule
Use Formula

If Cell = 0 Then Red

New Rule

If Cell A1>=10 Then Green

There should be a manager when you use rule and formulas

Thank you, sir. If I want the selected area with conditional formatting using above rule, is it possible to use the color instead of the text?

My apology i dont understand your rule.

http://www.techrepublic.com/blog/10-...tting-feature/


Yeah I think so

=IFERROR(COLUMN()<MATCH("C",$L1:$GV1,0)+COLUMN($K1),0)

and

=IFERROR(COLUMN()>MATCH("L",$L1:$GV1,0)+COLUMN($K1),0)

This is how to enter them:

Select cell L1

Note: If row 1 is not a row that you want this formatting for, just choose another cell, Ln, and change 1 to n everywhere in the formulas.

1. Click on Conditional Formatting in the Styles section of the Home tab.

2. Select New Rule... -> Use a formula to decide which cells to format

3. Enter the first formula in the Format values where this formula is true box

4. Click on Format... and select the formatting you want.

5. OK yourself out of the dialogues.

Repeat steps 1-5 and enter the second formula and the format you like for that.

Finally used the Format painter in the Clipboard section of the Home tab to "paint" this conditional formatting to the range L1:GV1


http://answers.microsoft.com/en-us/o...9-6face4870732

=IFERROR(COLUMN()<MATCH("C",$L1:$GV1,0)+COLUMN($K1),0)

and

IFERROR(COLUMN()>MATCH("L",$L1:$GV1,0)+COLUMN($K1),0)

This is how to enter them:

Select cell L1

Note: If row 1 is not a row that you want this formatting for, just choose another cell, Ln, and change 1 to n everywhere in the formulas.

1. Click on Conditional Formatting in the Styles section of the Home tab.

2. Select New Rule... -> Use a formula to decide which cells to format

3. Enter the first formula in the Format values where this formula is true box

4. Click on Format... and select the formatting you want.

5. OK yourself out of the dialogues.

Repeat steps 1-5 and enter the second formula and the format you like for that.

Finally used the Format painter in the Clipboard section of the Home tab to "paint" this conditional formatting to the range L1:GV1


http://answers.microsoft.com/en-us/o...9-6face4870732