Sample color test.xlsx
I would like When fields in the G:Z range have the fill color Yellow, it calculate its respective row of column "D" + "F2"
If the Color is Green, it calculate its respective row of column "C" + "D" + "F2".
I have searched the forum and tried variations of this but nothing the would calculate based on color. not real sure if a conditional format could solve this or maybe a macro. Just not savvy enough to figure it out yet.
Thanks In advance
Bookmarks