Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto colour when other conditions already in place
Hi
I have a sheet where multiple conditions are already applied using CFPlus (my new best friend!!) but now I want to have a selection of cells on that sheet (some already conditioned some not) turn a specific colour as soon as any particular cell in a stated range =16 - would I do this just by adding yet another format or would you suggest something else?? -- Thanks Lise (Aussie) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto colour when other conditions already in place
Hi Lise,
I'm working on CFs now as well (my question/struggle listed right below yours right now). Looking at your situation I believe you have two options. 1. If statement for =16 and then delete previous CF and add a new one for all cells desired. 2. If statement for =16 and then delete previous CF and simply ColorIndex all cells desired with new choice. In the long run they differ in that if a cell value where to drop below 16, then if you use method 1, the cell will change. Method 2 is a definite change, not temporary like a CF. Hope that helped. Since, NP On 7¤ë7¤é, ¤È«á2:30, Lise wrote: Hi I have a sheet where multiple conditions are already applied using CFPlus (my new best friend!!) but now I want to have a selection of cells on that sheet (some already conditioned some not) turn a specific colour as soon as any particular cell in a stated range =16 - would I do this just by adding yet another format or would you suggest something else?? -- Thanks Lise (Aussie) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I auto refresh a column that has an auto filter in place | Excel Discussion (Misc queries) | |||
Auto sum returns a 0 value in place of sum of values in column. | Excel Discussion (Misc queries) | |||
"IF" function, have the facility to place a colour in the cell | Excel Worksheet Functions | |||
Auto Decimal Place Application | Excel Discussion (Misc queries) | |||
formula help to change row colour automatically by some conditions | Excel Worksheet Functions |