Hello All,
Is there a way to transform a cell's fill color into some sort of data?
(I've inherited a bunch of worksheets where each cell has a number value and then the fill color says what the value is for.....the previous person then counted the values by hand and put them in another spread sheet
. )
(I didn't have any luck googling for this....all I get is going in the other direction with conditional formatting)
Thanks,
Alex
Is there a way to transform a cell's fill color into some sort of data?
(I've inherited a bunch of worksheets where each cell has a number value and then the fill color says what the value is for.....the previous person then counted the values by hand and put them in another spread sheet

(I didn't have any luck googling for this....all I get is going in the other direction with conditional formatting)
Thanks,
Alex