 |
 | 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 / January 2007Formula to print a datum in color contingent on value.
I need a formula that will change the displayed color of a value based on amount. For example: under 200=yellow, over 200=red. Also, can I add input from a third column? For example: under 200 and Column D=No, then yellow. under 200 and column D=yes, then green. Try conditional formatting for the cells Click on /scroll over cells you need to format FORMAT>CONDITIONAL FORMATTING > I need a formula that will change the displayed color of a value based on > amount. > For example: under 200=yellow, over 200=red. > Also, can I add input from a third column? > For example: under 200 and Column D=No, then yellow. > under 200 and column D=yes, then green. Can I add a third variable as in my second example? (Value greater then 200 and Column D "yes" then red, Column D "no" then yellow? > Try conditional formatting for the cells > Click on /scroll over cells you need to format [quoted text clipped - 6 lines] > > For example: under 200 and Column D=No, then yellow. > > under 200 and column D=yes, then green. Hi Try =AND(C2>200,D2="NO") Format Yellow =AND(C2>200,D2="YES") Format Red  SignatureRegards Roger Govier > Can I add a third variable as in my second example? (Value greater > then 200 [quoted text clipped - 11 lines] >> > For example: under 200 and Column D=No, then yellow. >> > under 200 and column D=yes, then green. Where? Do I put these formulae in the Conditional formatting pop up box? Under "Cell value is" or "formula is"? Thanks. > Hi > [quoted text clipped - 19 lines] > >> > For example: under 200 and Column D=No, then yellow. > >> > under 200 and column D=yes, then green. Sorry, I thought you had already got to that part. It is under Formula Is SignatureRegards Roger Govier > Where? Do I put these formulae in the Conditional formatting pop up > box? [quoted text clipped - 25 lines] >> >> > For example: under 200 and Column D=No, then yellow. >> >> > under 200 and column D=yes, then green.
|
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.