VBA - copy value from cell above with a certain color

VytautasM

New Member
Joined
Jan 31, 2020
Messages
18
Office Version
  1. 2010
Platform
  1. Windows
Good day,

Need any suggestions for a code to put me on the right track. Code must search for the first cell above that contains a certain color and copies its value.

Capture.JPG


If a value is entered into cell D1, cells below that have a meaning in column B, copy the value of the first cell above with the a grey color. If D1 value is deleted or changed, cells below update there values according.
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

VytautasM

New Member
Joined
Jan 31, 2020
Messages
18
Office Version
  1. 2010
Platform
  1. Windows
Good day,

Found another solution with some cell locking and a formula from Fluff.

Thread can be close.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,451
Messages
5,528,827
Members
409,839
Latest member
akashsadhu
Top