Conditional Formula.

serge

Well-known Member
I have a chart with a CF as : Equal to " within the CF set up, but I wanted to know if it would be possible to have this " Equal to " to be a cell outside the CF set up but on the chart itself that would represent the whole column ? the reason why is because I would like to see if I can change the cell data to see different result using the same chart ?

I hope I explain it right ?

Last edited:

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

DRSteele

Well-known Member
Are you trying to say that you want to type "IE" in that yellow cell and have the ConfFrmt refer to column IE? Then you'd like to type in, say, IH and the ConfFrmt would accommodate?

Last edited:

serge

Well-known Member
Yes but I'm pretty sure its not possible I was just curious to see if maybe ?

DRSteele

Well-known Member
I too suspected it's impossible. But it isn't. Try this.

I put random numbers of 1 and 0 in ColJJ. The CondFrmt formula looks at ColJJ and compares it to the values on the same rows in the column you name in cell JK2. If they are the same, the cell is formatted RedFill|WhiteFont. Change the cell JK2 to, for example, IG and the CondFrmt accommodates.

The ConfFrmt rule to apply to relevant cells is equal to this formula

=OFFSET(IE7,,COLUMN(INDIRECT(\$JK\$2&"1"))-COLUMN(\$IE\$1))

Last edited:

serge

Well-known Member

Thank you DRSteele,

I tried it but I must not have done the right thing, here is my set up.

Fluff

MrExcel MVP, Moderator
=JK7=OFFSET(\$IE7,,COLUMN(INDIRECT(\$JK\$2&"1"))-COLUMN(\$IE\$1))

serge

Well-known Member

Thank you Fluff, this works good, Appreciate your help.

Thank you DRSteele for the help also.

Serge.

Fluff

MrExcel MVP, Moderator
Glad we could help & thanks for the feedback

You're welcome.

Replies
2
Views
53
Replies
10
Views
86
Replies
0
Views
29
Replies
9
Views
76
Replies
3
Views
62