Conditional Formula.

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,264
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:

Some videos you may like

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
Joined
Mar 31, 2015
Messages
2,290
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Oct 8, 2008
Messages
1,264
Office Version
  1. 2007
Platform
  1. Windows
Yes but I'm pretty sure its not possible I was just curious to see if maybe ?
 

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,290
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Oct 8, 2008
Messages
1,264
Office Version
  1. 2007
Platform
  1. Windows

ADVERTISEMENT

Thank you DRSteele,

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

 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,340
Office Version
  1. 365
Platform
  1. Windows
How about using this formula
=JK7=OFFSET($IE7,,COLUMN(INDIRECT($JK$2&"1"))-COLUMN($IE$1))
 

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,264
Office Version
  1. 2007
Platform
  1. Windows

ADVERTISEMENT

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

Thank you DRSteele for the help also.

Serge.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,340
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,109,032
Messages
5,526,353
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top