| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indent and format based on Col A
5
Hello, I have a spreadsheet that has numbers in column A and Text in column B. I would like to indent Column B based on the value in Column A as follows: If Column A Contains Indent Column B # spaces 1 0 2 5 3 10 4 15 5 20 6 25 Also Column K contains the text yes or no. If Column K = yes Format Col B:J font = bold and shade cell light gray. Can someone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indent based on character length | Excel Discussion (Misc queries) | |||
| Indent based on Entry | Excel Discussion (Misc queries) | |||
| Format CellsAlignmentIndent | Excel Discussion (Misc queries) | |||
| Macro to Outline based on Indent Level | Excel Programming | |||
| Excel VBA - Best way to indent one column based on another | Excel Programming | |||
Threaded Mode
