Formula to determine Cell Color Format (Shading)

  • Thread starter Kimberly Jaeger
  • Start date
K

Kimberly Jaeger

I was wondering if there is any formula or macro to use
to evaluate cells that contain a certain format.
I want to create a Yes/No column for when cells are
formatted with a color so that I can sort a large amount
of data based on the color the cell is shaded.
Ideas appreciated.
I don't want to do find>all by format that is available
on the Finder menu because I cannot populate the other
column based on that and I want to be able to frequently
evaluate only rows of data contain the cells colored a
certain way.
 
I

igor

you can use a macro that will analyze the color like:

if sheets("sheet1").cell(1,1).interior.colorindex=5
then cell(1,2)="YES"

or something similar

good luck
 
Top