Conditional Formula.

[serge]

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 ?

 

[DRSteele]

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?

 

[serge]

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

 

[DRSteele]

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))

 

[serge]

Thank you DRSteele,

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

 

[Fluff]

How about using this formula
=JK7=OFFSET($IE7,,COLUMN(INDIRECT($JK$2&"1"))-COLUMN($IE$1))

 

[serge]

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

Thank you DRSteele for the help also.

Serge.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[DRSteele]

You're welcome.