Need to apply conditional formatting to large range of cells

Hello everyone,

I have a conditional format that I need applied to almost 120 rows.

I recorded the conditional format as i set it up.

Please Login or Register  to view this content.

How can I apply this exact same conditional format to all the rows I need?

Wouldn't this need to me some kind of loop?

I have no clue how to change the range each time the condition is applied. Basically I need the condition applied to a row, move down to the next row and apply the same condition. Changing the "$F$3="No """ to F4, F5, F6, etc...

Sample attached.

Thank you in advance.

Justin

• Select the entire range in your macro.
• Apply the CF formula using a relative reference for the row e.g.: Formula1:= "=$F3=""No """
• Excel will automatically adjust the formulas for each row.

You need to change the range to include the rows you want and take out the absolute row reference.
If your range is B3:K30 (for example), then use this:

Please Login or Register  to view this content.

Note that each time you run this code, it will create a new version of the CF rule, so you may also want to add this line after the range selection:

Please Login or Register  to view this content.

Hope that helps.

Out of curiosity, is there a reason why you need this to be done in VBA rather than just using CF directly?

When I try to do this directly in CF it bugs up. Only some of the cells are formatted. Apparently this is a know issue in excel. If I try to apply the rule to each individual row it will take me forever and I only have 30 minutes to get this completed.

Correction,

I'm just an idiot whos rushing too much lol. It worked fine when I applied the rules as AlphaFrog directed.

Thanks a ton!!

Okay - I do sometimes get the issue of CF applying incorrectly, though the issue I've seen is quite easy to fix. However, VBA works as well - have you tried the suggestions above (mine and AlphaFrog's are essentially the same - expand the range and take out the $ before the 3 in $F$3 so it's $F3)?

You're welcome - thanks for the feedback and the rep.
Now that your problem's solved, please mark the thread as Solved so others know there's an answer here (see my sig for instructions). Thanks.