Conditional formatting

Hi Edward

Thank you for the question which has two answers.

Yes it is possible to conditionally format cells dependant upon other cells. When you set up the conditional formatting drop down the first box inside the condition and change it to "Formula Is" then you can put the condition based on the other cell. Using your example the first condition would be

=$A$1="GBP"

Although this partly answers your question the example you cannot apply number formatting in conditional formatting in Excel 2003.

Hope that helps.

Laura GB

Hi Edward

Your requirement falls out of the ambit of this forum, as it will require dedicated time from one of our trainers to resolve. We offer this as a consulting service that we can either do at your site or remotely. Consultancy rates start from