cell color index?

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hello,
I need to return a number value in a cell if a row is a certain color.

For example,
If Row 1 is Green, I would like the value in Column A1 to be "6".
If Row 2 is Blue, I want the value in Column A2 to be "4".

Seems easy, but I can't figure out a way to do it...

Thanks,

Dan
 
there are countless posts on this forum regarding colors and formulas, and
most will point you towards Chip Pearson's website-- the specific page I
don't know off hand.

www.cpearson.com
 
Back
Top