Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Conditional formatting
Resolved · High Priority · Version 2003
Reply Thu 16 Oct 2008, 15:40Delegate Edward said...
Edward has attended:
Excel VBA Intro Intermediate course
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Conditional formatting
Is it possible to conditionally format cells dependent on another cell, and could that formatting include a currency symbol?
For example if i had a dropdown in cell A1 for currency and i selected GBP or EUR, could i set up say cell B2 to show
For upcoming training course dates see: Pricing & availability
RE: 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
RE: Conditional formatting
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
|