R
Robert Temple
Is there any formula to identify if a range of cells have a color fill?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Rothstein
Formulas can't see colors. How did the color(s) get into the cell... by
Conditional Formatting or manually? If by Conditional Formatting, then you
should be able to use its formula as your test condition. If manually
placed, then you will need VB code. Either way, I think you will have to
supply a more detailed description of what you are attempting to do.
Conditional Formatting or manually? If by Conditional Formatting, then you
should be able to use its formula as your test condition. If manually
placed, then you will need VB code. Either way, I think you will have to
supply a more detailed description of what you are attempting to do.
R
Robert Temple
Thanks for the Reply Rick.
That was the 1st search I did to find if there was a conditional format.
Unfortunately, there is none and the color was entered manually. More detail:
I am have approximatley 900 lines of data and the colored lines represent
closed projects. The non-colored lines are projects still open. I was hoping
I could do a formula to quickly tell me how many projects are open based on
the lines being colored.
Robert
That was the 1st search I did to find if there was a conditional format.
Unfortunately, there is none and the color was entered manually. More detail:
I am have approximatley 900 lines of data and the colored lines represent
closed projects. The non-colored lines are projects still open. I was hoping
I could do a formula to quickly tell me how many projects are open based on
the lines being colored.
Robert
R
Rick Rothstein
Is the color the only way a row is indicated as being closed? I mean is
there a column with a "final date" in it or some other cell entry that let's
you know the row is closed? If so, then two things... one, a Conditional
Format can be built around it to color the closed cells instead of manually
coloring them and, two, it can be used to count the closed rows. It seems
unlikely to me that the color is the only way a row can be determined to be
closed... I mean, how would anyone know if a line got colored by mistake?
there a column with a "final date" in it or some other cell entry that let's
you know the row is closed? If so, then two things... one, a Conditional
Format can be built around it to color the closed cells instead of manually
coloring them and, two, it can be used to count the closed rows. It seems
unlikely to me that the color is the only way a row can be determined to be
closed... I mean, how would anyone know if a line got colored by mistake?