MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Color Change Macro detecting fonts

  Asked By: Madeline    Date: Oct 10    Category: MS Office    Views: 833

I'm currently working on an Excel project and I'm stumped for a
solution. I have an array of data that changes in size. I'm using
condition formating to change data in certain columns to bold that are
out of specification. The problem I'm having now is trying to figure
out how to write a macro that will look through every row and look for
these bolded cells and change the background color of the entire row
to red. Any recommendations?



1 Answer Found

Answer #1    Answered By: Oliver Jones     Answered On: Oct 10

I think you will need to step through the rows, carry out the test - whatever
you used for the conditional formatting - and then color  the rows.

I do not think it is possible just to look at the cell and see what colour the
conditional formatting makes it.

Didn't find what you were looking for? Find more on Color Change Macro detecting fonts Or get search suggestion and latest updates.