|
|
#1
06-30-2016, 04:16 AM
|
|||
|
|||
Can you help me with this formula?
I have made this formula to alternate colours based on grouping with the 'Works Order' column. However, I would like it to update when I hide certain rows.
For example, if I was to hide row 4, then id like it to automatically shade the 3 rows with '304461' in column A. Currently, this only works if I delete the row, and this is not what I want to do. Any help would be greatly appreciated, Thanks, Mike. Last edited by mikey1984; 06-30-2016 at 04:18 AM. Reason: Forgot the image. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Need help with IF formula
|
SMI | Word | 3 | 01-19-2016 06:33 AM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
|
Formula Help
|
ashreporter | Excel | 3 | 04-01-2015 10:40 PM |
|
IF + AND formula help
|
david_89_ | Excel | 4 | 06-11-2014 11:07 AM |
|
formula help
|
rich_cirillo | Excel | 3 | 09-26-2012 11:41 PM |
Windows 7 64bit 
Office 2016
Threaded Mode