| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting
I need to set conditional formatting based on multple separate cells within a
sheet. I'm looking to change the color of a cell, based on , <, or = conditions, of 25 other cells that are not connected to eachother. I'm thinking I may need to do a macro, but am not familiar enough with them, nor Excel to figure it out. Any help will be GReATLY appreciated. Thanks, Dean |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting
It might be easier to use a Helper column that contains a formula that looks
at these 25 other cells and returns TRUE or FALSE. Then your CF formula can refer just to that one cell. A caveat: you say 25 cell. Remember that the limit on nested IF statement is 7. Also, you have only 3 conditional formats plus the default format. On Sat, 19 Feb 2005 14:47:01 -0800, "Dean" wrote: I need to set conditional formatting based on multple separate cells within a sheet. I'm looking to change the color of a cell, based on , <, or = conditions, of 25 other cells that are not connected to eachother. I'm thinking I may need to do a macro, but am not familiar enough with them, nor Excel to figure it out. Any help will be GReATLY appreciated. Thanks, Dean |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
