Format cell based on cell color

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

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
 
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!
 
How did your cells in Columns B through AO get to be "red filled"...
manually filled with the color or via Conditional Formatting? If Conditional
Formatting, what formula was used?
 
via Conditional Formatting.

There are multiple columns being checked with conditional formatting that
count the number of characters in the column to the left. Each conditional
formatting statement is a Greater Than statement, so if the characters
allowed for that column is exceeded, the cell is highlighted red. I have a
macro that checks several columns between B and AO....now I need to get those
rows to the top.

Thanks,
Jim
 
Back
Top