If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting when inserting a row
My conditional formatting is =SUM($E$2:$E$9)$E$1. When this returns true, all of the cells E2:E9 turn red. But in the future, I will need to insert a row that needs to be included in the conditional formatting. Assume that the conditional formatting returns false. When I do insert a row, all of the cells turn red because the last row is pushed down to E10 and therefore is not included in the original conditional formatting function. Also, if I were to add in data at E10, is there a way to automatically update the conditional formatting function to include this cell? Help is appreciated. -- zahoulik |
#2
|
|||
|
|||
Conditional Formatting when inserting a row
Hi
Set up a named range InsertNameName Myrange Refers to =INDEX($E:$E,2,0):INDEX($E:$E,MATCH(9.999999999999 99E+307,$E:$E)) Change your conditional formatting formula to =SUM(Myrange)$E$1 Regards Roger Govier zahoulik wrote: My conditional formatting is =SUM($E$2:$E$9)$E$1. When this returns true, all of the cells E2:E9 turn red. But in the future, I will need to insert a row that needs to be included in the conditional formatting. Assume that the conditional formatting returns false. When I do insert a row, all of the cells turn red because the last row is pushed down to E10 and therefore is not included in the original conditional formatting function. Also, if I were to add in data at E10, is there a way to automatically update the conditional formatting function to include this cell? Help is appreciated. |
#3
|
|||
|
|||
Conditional Formatting when inserting a row
Have you tried inserting your row anywhere between row 3 and 8?
"zahoulik" wrote in message ... My conditional formatting is =SUM($E$2:$E$9)$E$1. When this returns true, all of the cells E2:E9 turn red. But in the future, I will need to insert a row that needs to be included in the conditional formatting. Assume that the conditional formatting returns false. When I do insert a row, all of the cells turn red because the last row is pushed down to E10 and therefore is not included in the original conditional formatting function. Also, if I were to add in data at E10, is there a way to automatically update the conditional formatting function to include this cell? Help is appreciated. -- zahoulik |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting | sweetsue516 | General Discussion | 7 | September 20th, 2005 08:16 PM |
conditional formatting on a PivotTable? | confused | Charts and Charting | 0 | June 13th, 2005 04:15 PM |
conditional formatting conflict? | Abi | Worksheet Functions | 2 | January 11th, 2005 03:41 PM |
Greater than formulas with conditional formatting | Jamie | New Users | 1 | May 21st, 2004 04:32 AM |
MIN value exclude '0' & Conditional Formatting | JEM | Worksheet Functions | 5 | April 16th, 2004 03:40 AM |