Indent and fill color based on other columns data
 

I need some advice on how to automatically update the formatting in a
spreadsheet.

I have data in Columns A:J. I would like to fill color gray for A2:H2 if
Col J 2 = Yes. I would also like to indent column B the following spaces
based on a number in column H.
Example:

If Column H2 = 2 then indent H2 text 3 spaces
If Column H2 = 3 then indent H2 text 6 spaces
If Column H2 = 4 then indent H2 text 9 spaces
If Column H2 = 5 then indent H2 text 12 spaces
If Column H2 = 6 then indent H2 text 15 spaces

I would like VBA if that is possible.

thanks in advance
clvl

Indent and fill color based on other columns data
 

The SS may have 10 to 1000 rows of data.

"CB" wrote:

I need some advice on how to automatically update the formatting in a
spreadsheet.

I have data in Columns A:J. I would like to fill color gray for A2:H2 if
Col J 2 = Yes. I would also like to indent column B the following spaces
based on a number in column H.
Example:

If Column H2 = 2 then indent H2 text 3 spaces
If Column H2 = 3 then indent H2 text 6 spaces
If Column H2 = 4 then indent H2 text 9 spaces
If Column H2 = 5 then indent H2 text 12 spaces
If Column H2 = 6 then indent H2 text 15 spaces

I would like VBA if that is possible.

thanks in advance
clvl