Conditional Format a Row (Macro)

[jamessaunders]

Hi Guys,

i need to format cell colours of a row based on contents of certain cells, conditional formatting is no good as there are too many arguments I beleive.

Please see attached which will explain my requirements.

Many thanks

James

[Greg M]

Hi James,

Try the attached - I think it does what you need. If the values in cells G:K are changed to "Yes" or "No", the rows are automatically reformatted in accordance with what you specified.

The VBA code is completely parameterised, i.e. the various background & text colours can be changed easily, as can the location of the "monitored" columns G:K should you wish to add/delete columns later.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[jamessaunders]

Works a treat, just what i wanted. Many thanks Greg.

[Greg M]

Hi again James,

Thanks for the feedback. You're welcome - glad to have helped.

All the best,

Greg M