Formatting with colors with if condition in VBA

[kishoremcp]

I have 50 rows in which I need to format the entire filled cells with a pirticular format.
The below macro is which i want to use for formatting that filled cells if the rows has a word Total then formatting should apply.

The formatting macro which i have is

Please Login or Register  to view this content.

[FDibbins]

why do you need a macro for this, when you do it quite easily with regular conditional formatting?

[kishoremcp]

As I am trying to automate it .
I got something here from google and it is formatting for entire row with the given condition. I need to format only the filled cells. Could you please edit the below macro and see that it will format only the cells which are filled.

Please Login or Register  to view this content.

[kishoremcp]

Any help is appreciated

[smugglersblues]

Here is a macro I'm using. You just need the RGB color code (google for codes).

Please Login or Register  to view this content.