Conditional formatting; changes colors by itself.

Johnwash

New Member
Joined
Jan 26, 2005
Messages
1
Help!!!! :confused:

I have a spreadsheet where I have roughly 20 cells that are conditional formatted. I have chosen two colors, red and green. Also in the workbook are many graphs. When I make changes to the graphs and go back to the tab where the conditional formatting is, the colors have changed??? The weird thing is that the data that is being entered is coming from another workbook. I need to know why this is happening?????

Very frustrated!

John
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

parry

MrExcel MVP
Joined
Aug 20, 2002
Messages
3,355
Hi John, welcome to the board. Conditional formatting will change the colour based upon whether the c/f condition is true. This is often related to the value of the cells that are coloured for conditional formatting but not necessarily so if fomula criteria is used.

The chart will change its values based upon changes to the data source but not the other way around. Changing the atributes of a chart should have no affect on the data source.

You may have to provide more information such as what the c/f criteria is, which cells are changing colour and their values plus what changes you are actually making to the chart.
 

vconfused

Well-known Member
Joined
Jun 11, 2004
Messages
547
Are you changing the colors in the charts?

What version of Excel are you using, maybe we could replicate the problem.
 

Forum statistics

Threads
1,147,622
Messages
5,742,197
Members
423,711
Latest member
luisfreitas

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
Top