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
|