| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I have a macro format cells while recording?
I am attempting to record a macro similar to the one below, however at the
end of the data/sort I want to include cell formatting so that the top three automatically appear in green, and the fourth automatically appears in red. Is this possible? Range("A4:H15").Select Selection.Sort Key1:=Range("A4"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format cells and enter data to be valued for TIME and th. | Excel Worksheet Functions | |||
| format cells | Excel Worksheet Functions | |||
| Format Macro Buttons? | Excel Discussion (Misc queries) | |||
| My sheet is unprotected, but I can't format cells. | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Threaded Mode
