 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Conditional Formating
Is it possible to use conditional formatin in Excel 2003 to: value cell is in red if it's format is accounting - Dollars value cell is in blue if it's format is accounting - Euros Yes Use "cell value is equal to" in conditional formatting. You will have to ensure you use the required currency symbol ($ / €) as you enter the the amount in each cell ie $12000 €12000 CG1954 > Is it possible to use conditional formatin in Excel 2003 to: > value cell is in red if it's format is accounting - Dollars > value cell is in blue if it's format is accounting - Euros The cell are preformated as accounting: either dollars ($) or (€) . When I enter a number in a cell it will automaticcly have the sign shown. Of course the cells contains different values. > Yes > Use "cell value is equal to" in conditional formatting. [quoted text clipped - 9 lines] >> value cell is in red if it's format is accounting - Dollars >> value cell is in blue if it's format is accounting - Euros Say A1 is formatted for $'s, And A2 for €'s. In B1 enter: =Cell("format",A1) And copy down to B2. B1 returns < C2 > And B2 returns < ,2 > SO ... conditional formulas such as: =CELL("format",A1)="C2" And =CELL("format",A1)=",2" should work for you for condition 1 and condition 2 formulas set with your colored formats.  SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== The cell are preformated as accounting: either dollars ($) or (€) . When I enter a number in a cell it will automaticcly have the sign shown. Of course the cells contains different values. > Yes > Use "cell value is equal to" in conditional formatting. [quoted text clipped - 11 lines] >> value cell is in red if it's format is accounting - Dollars >> value cell is in blue if it's format is accounting - Euros Works for some cells and doesn't work for other values in the range. Is there anything special???? The condition is "and" in conditional formating which gives the impresion that it sould fulfill BOTH conditions!!! > Say A1 is formatted for $'s, > And A2 for €'s. [quoted text clipped - 37 lines] >>> value cell is in red if it's format is accounting - Dollars >>> value cell is in blue if it's format is accounting - Euros I don't follow what you mean when you say: <<<"The condition is "and" in conditional formatting">>> Use "Formula is" with =CELL("format",A1)="C2" for Condition1 format to Red- Use "Formula is" with =CELL("format",A1)=",2" for Condition2 format to Green- SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Works for some cells and doesn't work for other values in the range. > Is there anything special???? [quoted text clipped - 43 lines] >>>> value cell is in red if it's format is accounting - Dollars >>>> value cell is in blue if it's format is accounting - Euros Thanks for the help >I don't follow what you mean when you say: > <<<"The condition is "and" in conditional formatting">>> [quoted text clipped - 57 lines] >>>>> value cell is in red if it's format is accounting - Dollars >>>>> value cell is in blue if it's format is accounting - Euros You're welcome, and appreciate the feed-back. Also, check your system clock! SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Thanks for the help > [quoted text clipped - 60 lines] >>>>>> value cell is in red if it's format is accounting - Dollars >>>>>> value cell is in blue if it's format is accounting - Euros
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.