Conditional Formula.

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,399
Office Version
  1. 2007
Platform
  1. Windows
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.
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:
Upvote 0
Yes but I'm pretty sure its not possible I was just curious to see if maybe ?
 
Upvote 0
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:
Upvote 0
Thank you DRSteele,

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

33katjs.jpg
 
Upvote 0
How about using this formula
=JK7=OFFSET($IE7,,COLUMN(INDIRECT($JK$2&"1"))-COLUMN($IE$1))
 
Upvote 0
Thank you Fluff, this works good, Appreciate your help.

Thank you DRSteele for the help also.

Serge.
 
Upvote 0
Glad we could help & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,941
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top