| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Row Conditionally
I have a spreadsheet that changes from month-to-month. I have a Macro that
does different formatting and I wanted to do something odd. Column J has nearly all dates, however, periodically there is text. Either "Billing: #" or "Complete: #". If "Billing" or "Complete" shows up I want that entire row to be formatted differently. The default format is center, if this text appears I want the format to be, ".HorizontalAlignment = xlGeneral" and ".VerticalAlignment = xlTop". Does this makes sense? Is it possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditionally format anumber format | Excel Worksheet Functions | |||
| How do I conditionally format a chart? | Charts and Charting in Excel | |||
| Conditionally format row height | Excel Programming | |||
| How do I conditionally format a chart? | Excel Discussion (Misc queries) | |||
| Conditionally format | Excel Programming | |||
Threaded Mode
