Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 1 cellthat looks at 3 cells.
Thank you experts for all your help:
Question: Conditionl format formula for "N7" 1. If C7,D7,E7 are 28 turn red 2. If C7,D7,E7 are <28 turn green I can do the color part(easy I know) Queston: Is there a way around the 3 conditional format limit for a cell? Thank you in advance. Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 1 cellthat looks at 3 cells.
Your question is ambiguous. If you mean that all of C7,D7,E7 should be 28 to
turn the cell red then =AND(C728,D728,E728) the same for green with < instead of . If this is not the case, specify it! Regards, Stefi €˛Mark€¯ ezt Ć*rta: Thank you experts for all your help: Question: Conditionl format formula for "N7" 1. If C7,D7,E7 are 28 turn red 2. If C7,D7,E7 are <28 turn green I can do the color part(easy I know) Queston: Is there a way around the 3 conditional format limit for a cell? Thank you in advance. Mark |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 1 cellthat looks at 3 cells.
With N7 selected, click on Format | Conditional Formatting and choose
Formula Is rather than Cell Vlaue Is in the first box. Enter this formula: =AND(C728,D728,E728) Then click the Format button, choose the Patterns tab and choose red. Click OK, then Add to set up your second condition. Formula Is again, with this formula: =AND(C7<28,D7<28,E7<28) Set this for green, then OK twice to exit the dialogue boxes. The formulae will set the colours if all 3 conditions are met. XL2007 has more conditional formats per cell (I think it's about 60), and Bob Phillips has a free add-in he http://www.xldynamic.com/source/xld.....Download.html which will give you up to 30. Hope this helps. Pete On Feb 5, 2:19*pm, Mark wrote: Thank you experts for all your help: Question: Conditionl format formula for "N7" 1. If C7,D7,E7 are 28 turn red 2. If C7,D7,E7 are <28 turn green I can do the color part(easy I know) Queston: Is there a way around the 3 conditional format limit for a cell? Thank you in advance. Mark |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 1 cellthat looks at 3 cells.
Hi Mark
If you're using XL2003 and older, the answer is NO except a macro will do it. HTH John "Mark" wrote in message ... Thank you experts for all your help: Question: Conditionl format formula for "N7" 1. If C7,D7,E7 are 28 turn red 2. If C7,D7,E7 are <28 turn green I can do the color part(easy I know) Queston: Is there a way around the 3 conditional format limit for a cell? Thank you in advance. Mark |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 1 cellthat looks at 3 cells.
Try this:
1) Conditional Format for Cell (N7) Conditional1: Red =IF(OR($C$728,$D$728,$E$728),TRUE,FALSE) Condition2: Green =IF(OR($C$7<28,$D$7<28,$E$7<28),TRUE,FALSE) 2) Enter a formula to Cell (N7) =MAX(C7:E7) 3) Now you try enter any number in cells C7,D7,E7. Regards. "Mark" wrote in message ... Thank you experts for all your help: Question: Conditionl format formula for "N7" 1. If C7,D7,E7 are 28 turn red 2. If C7,D7,E7 are <28 turn green I can do the color part(easy I know) Queston: Is there a way around the 3 conditional format limit for a cell? Thank you in advance. Mark |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 1 cellthat looks at 3 cells.
Yes, it's exact now! The formulae are
=SUM(C7:E7)28 and =SUM(C7:E7)<28 Regards, Stefi €˛Mark€¯ ezt Ć*rta: O I see now what you meant NO! C7+D7+E7 sum 28 is more clear? Mark "Mark" wrote: Thank you experts for all your help: Question: Conditionl format formula for "N7" 1. If C7,D7,E7 are 28 turn red 2. If C7,D7,E7 are <28 turn green I can do the color part(easy I know) Queston: Is there a way around the 3 conditional format limit for a cell? Thank you in advance. Mark |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 1 cellthat looks at 3 cells.
Stefi,
I'm not smart enough to be ambiguous! Barring that. Yes! C7 + D7+ E7 if than 28 cell N7 colors. each cell has a number. Is what you wrote still the same formula. Thank you for helping. Mark. "Mark" wrote: Thank you experts for all your help: Question: Conditionl format formula for "N7" 1. If C7,D7,E7 are 28 turn red 2. If C7,D7,E7 are <28 turn green I can do the color part(easy I know) Queston: Is there a way around the 3 conditional format limit for a cell? Thank you in advance. Mark |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 1 cellthat looks at 3 cells.
O I see now what you meant
NO! C7+D7+E7 sum 28 is more clear? Mark "Mark" wrote: Thank you experts for all your help: Question: Conditionl format formula for "N7" 1. If C7,D7,E7 are 28 turn red 2. If C7,D7,E7 are <28 turn green I can do the color part(easy I know) Queston: Is there a way around the 3 conditional format limit for a cell? Thank you in advance. Mark |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 1 cellthat looks at 3 cells.
Thank you Pete. osh, the help hee is fanatstic.
"Pete_UK" wrote: With N7 selected, click on Format | Conditional Formatting and choose Formula Is rather than Cell Vlaue Is in the first box. Enter this formula: =AND(C728,D728,E728) Then click the Format button, choose the Patterns tab and choose red. Click OK, then Add to set up your second condition. Formula Is again, with this formula: =AND(C7<28,D7<28,E7<28) Set this for green, then OK twice to exit the dialogue boxes. The formulae will set the colours if all 3 conditions are met. XL2007 has more conditional formats per cell (I think it's about 60), and Bob Phillips has a free add-in he http://www.xldynamic.com/source/xld.....Download.html which will give you up to 30. Hope this helps. Pete On Feb 5, 2:19 pm, Mark wrote: Thank you experts for all your help: Question: Conditionl format formula for "N7" 1. If C7,D7,E7 are 28 turn red 2. If C7,D7,E7 are <28 turn green I can do the color part(easy I know) Queston: Is there a way around the 3 conditional format limit for a cell? Thank you in advance. Mark |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 1 cellthat looks at 3 cells.
Perfect. Thank you very much
"Stefi" wrote: Yes, it's exact now! The formulae are =SUM(C7:E7)28 and =SUM(C7:E7)<28 Regards, Stefi €˛Mark€¯ ezt Ć*rta: O I see now what you meant NO! C7+D7+E7 sum 28 is more clear? Mark "Mark" wrote: Thank you experts for all your help: Question: Conditionl format formula for "N7" 1. If C7,D7,E7 are 28 turn red 2. If C7,D7,E7 are <28 turn green I can do the color part(easy I know) Queston: Is there a way around the 3 conditional format limit for a cell? Thank you in advance. Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionl format a cell to change text colour | Excel Discussion (Misc queries) | |||
conditionl format overrides explicit format | Excel Discussion (Misc queries) | |||
Conditionl Format | Excel Worksheet Functions | |||
HOW DO YOU GET A "0" OUTPUT FROM A CELLTHAT IS THE PRODUCT OF A V. | Excel Discussion (Misc queries) | |||
Formula and Conditionl Formatting Help | Excel Worksheet Functions |