Thread: [Solved] Can you help me with this formula?
View Single Post
 
Old 06-30-2016, 04:16 AM
mikey1984 mikey1984 is offline Windows 7 64bit Office 2016
Novice
  
Join Date: Jun 2016
Posts: 4
mikey1984 is on a distinguished road
Default 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.
Attached Images
File Type: png Capture.PNG (61.0 KB, 23 views)
Last edited by mikey1984; 06-30-2016 at 04:18 AM. Reason: Forgot the image.
Reply With Quote