|
|
#3
01-12-2015, 07:38 AM
|
|||
|
|||
Hi Charles. I've attached a redacted file here. To clarify a bit, hoping to run a conditional formatting function as an on off button that I can apply to several sheets in my workbook, all of which are modeled the same as this file attached. For each cell(C4:N15), I will ask the function to look at its respective variance(comparing its value to column Q) and if that absolute variance is greater than the average absolute deviation(column R), then it should be highlighted for review. make sense?
thanks for having a look. greg 
|
| Tags |
| active cell, calculation, loop |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Show result of formula as a value in another cell
|
Steve_D | Excel | 4 | 10-12-2014 07:38 PM |
|
Excel 2007, highlight entire row based on data found in one cell
|
MSofficeBLUE | Excel | 2 | 10-15-2013 09:51 PM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
| Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |
|
How to highlight the row based on cell value?
|
Learner7 | Excel | 1 | 12-11-2011 02:28 AM |
Windows 7 32bit 
Office 2003
Threaded Mode