| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
