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