If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fill Colour problem
Hi,
I've got a spreadsheet that has conditional formatting so the the fill colour of a cell goes Red, 'Amber' or Green dependant on the outcome of certain formulae. The formulae work fine but the 'amber' colour turns brown if I have 2 different spreadsheets open or if someone opens the file on a different machine. Any ideas whats causing this? |
#2
|
|||
|
|||
Fill Colour problem
This should not happen unless formulas refer to the other sheet.
Pl. share the formula... "Sulli" wrote: Hi, I've got a spreadsheet that has conditional formatting so the the fill colour of a cell goes Red, 'Amber' or Green dependant on the outcome of certain formulae. The formulae work fine but the 'amber' colour turns brown if I have 2 different spreadsheets open or if someone opens the file on a different machine. Any ideas whats causing this? |
#3
|
|||
|
|||
Fill Colour problem
Check to see if your workbook is using a custom color pallete. If the colors
are not the same as the standard Excel pallete, you can get color switching when you also have another workbook open that does use the standarad pallete. Look under Tools/Options/Color for your workbook and then for a new, blank workbook, to see if any of the standard colors have been altered. HTH, Eric "Sulli" wrote: Hi, I've got a spreadsheet that has conditional formatting so the the fill colour of a cell goes Red, 'Amber' or Green dependant on the outcome of certain formulae. The formulae work fine but the 'amber' colour turns brown if I have 2 different spreadsheets open or if someone opens the file on a different machine. Any ideas whats causing this? |
Thread Tools | |
Display Modes | |
|
|