J
James Black
Hi folks
Another Excel newbie requiring assistance with conditional formatting,
I'm afraid.
My problem:
I've been tasked by my employer to create a Spreadsheet in MS Excel
2003 for the purpose of displaying an XML *list* which is output from
one of our legacy 3GL systems.
I've created the spreadsheet using the map genetrated automatically by
Excel, based on the actual XML file to be imported, and I can import
the data at will. No problem there (I've set the import function to
overwrite all previously stored data on selecting the 'refresh all'
option on the import toolbar. Effectively, this whole exersise is
intended to produce a nicely formatted version of the standard business
report that would normally be churned out by our application).
My problem is that the conditional formatting I have applied to change
the colour of as many rows as contain a certain text value in column A,
is not being automatically reapplied when I perform a 'refresh all' -
although a check on the values shown in the Conditional Formatting
entry box shows the formatting to be in place.
Any suggestions on how to address this problem would be gratefully
received. This doesn't necessarily have to end up as an XML format
spreadsheet, as long as the solution preserves the updateable link to
the XML list.
TIA
Jim
Another Excel newbie requiring assistance with conditional formatting,
I'm afraid.
My problem:
I've been tasked by my employer to create a Spreadsheet in MS Excel
2003 for the purpose of displaying an XML *list* which is output from
one of our legacy 3GL systems.
I've created the spreadsheet using the map genetrated automatically by
Excel, based on the actual XML file to be imported, and I can import
the data at will. No problem there (I've set the import function to
overwrite all previously stored data on selecting the 'refresh all'
option on the import toolbar. Effectively, this whole exersise is
intended to produce a nicely formatted version of the standard business
report that would normally be churned out by our application).
My problem is that the conditional formatting I have applied to change
the colour of as many rows as contain a certain text value in column A,
is not being automatically reapplied when I perform a 'refresh all' -
although a check on the values shown in the Conditional Formatting
entry box shows the formatting to be in place.
Any suggestions on how to address this problem would be gratefully
received. This doesn't necessarily have to end up as an XML format
spreadsheet, as long as the solution preserves the updateable link to
the XML list.
TIA
Jim