Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting across many cells with a mobile comparison
Sounds to me like (at least I *HOPE*) that the Excel 2007 folks still have a
little work to do. Unless you have a range named as "C12". "Pat Clear" wrote: My description was probably more confusion than helpful but here we go... C4 has a hard coded value in it. The range C8:V8 has values created due to a formula (say something like D8 has =SUM(C8,D7) and E8 has =SUM(D8,E7). Now I've got another formula value in C12:V12, that I want used in the comparison. I highlight my range C8:V8 with C8 being the active cell. The formula I put in on my traffic lights is something along the lines of. 1) =(ROUNDUP($C$4/12,-2)*3)-C12 2) =(ROUNDUP($C$4/12,-2)*2)-C12 3) =(ROUNDUP($C$4/12,-2)*1)-C12 When I apply it - it works perfectly on C8.. but on D8:V8 it constantly points back to C12.. instead of progressing along to D12, E12, F12... Am I expecting incorrect functionality? I've gotten used to 97-2k3 performing that way. Or is there a way to get it to function this way. I've tried even formatting each one individually (a real pain when I'm doing a couple hundred cells) but it still behaves oddly (I'm hoping that's a beta thing). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using conditional formatting to "blank" cells | Excel Discussion (Misc queries) | |||
conditional formatting 2 cells | Excel Worksheet Functions | |||
Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
conditional formatting to multiple cells | Excel Worksheet Functions | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) |