Format cell based on cell color
Or...
Is there a way to go to the first cell in a column that is not formatted
Red? I could work with that as well.
I need to get all of the rows that have Red filled cells at the top of the
worksheet. With a macro I could sort one column at a time and not include
the pre-sorted (already identified Red) columns. Brainstorming on a Friday
afternoon, probably not a good idea. I appreciate your feedback!
"Jim" wrote:
Is there a way to format the cell in column A "Red Fill" if there is any cell
in that row in columns B through AO that have a Red filled cell?
If not, is there a way to color the cell in column A if the cell in column B
is Red filled? If that's possible, I could set up a macro to repeat the
process for the other columns.
Thanks for your help
Jim
|