Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula 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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula to print a datum in color contingent on value.
Try conditional formatting for the cells
Click on /scroll over cells you need to format FORMATCONDITIONAL FORMATTING "Shadyhosta" wrote: 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula to print a datum in color contingent on value.
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? "ufo_pilot" wrote: Try conditional formatting for the cells Click on /scroll over cells you need to format FORMATCONDITIONAL FORMATTING "Shadyhosta" wrote: 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula to print a datum in color contingent on value.
Hi
Try =AND(C2200,D2="NO") Format Yellow =AND(C2200,D2="YES") Format Red -- Regards Roger Govier "Shadyhosta" wrote in message ... 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? "ufo_pilot" wrote: Try conditional formatting for the cells Click on /scroll over cells you need to format FORMATCONDITIONAL FORMATTING "Shadyhosta" wrote: 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. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula to print a datum in color contingent on value.
Where? Do I put these formulae in the Conditional formatting pop up box?
Under "Cell value is" or "formula is"? Thanks. "Roger Govier" wrote: Hi Try =AND(C2200,D2="NO") Format Yellow =AND(C2200,D2="YES") Format Red -- Regards Roger Govier "Shadyhosta" wrote in message ... 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? "ufo_pilot" wrote: Try conditional formatting for the cells Click on /scroll over cells you need to format FORMATCONDITIONAL FORMATTING "Shadyhosta" wrote: 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. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula to print a datum in color contingent on value.
Sorry, I thought you had already got to that part.
It is under Formula Is -- Regards Roger Govier "Shadyhosta" wrote in message ... Where? Do I put these formulae in the Conditional formatting pop up box? Under "Cell value is" or "formula is"? Thanks. "Roger Govier" wrote: Hi Try =AND(C2200,D2="NO") Format Yellow =AND(C2200,D2="YES") Format Red -- Regards Roger Govier "Shadyhosta" wrote in message ... 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? "ufo_pilot" wrote: Try conditional formatting for the cells Click on /scroll over cells you need to format FORMATCONDITIONAL FORMATTING "Shadyhosta" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions |