Dannottheman
Board Regular
- Joined
- Dec 24, 2020
- Messages
- 55
- Office Version
- 2007
Hi,
I searched on Google but could not get a VBA to work. I am using Office 2007. I am looking for a VBA to shade rows with "x" color (e.g., light blue) based on cell value. For example, if any row in Column A contains the value "Lesson", it will shade that row light blue. I know I can use Conditional Formatting for this and I have in the past, but I have to do 3 or 4 different steps to the same sheet and I am hoping to just create one long VBA that will do all 4 things instead of having to do multiple steps manually. (I have more than 200 sheets to do). Any help would be appreciated. Thanks in advance and Merry Christmas.
I searched on Google but could not get a VBA to work. I am using Office 2007. I am looking for a VBA to shade rows with "x" color (e.g., light blue) based on cell value. For example, if any row in Column A contains the value "Lesson", it will shade that row light blue. I know I can use Conditional Formatting for this and I have in the past, but I have to do 3 or 4 different steps to the same sheet and I am hoping to just create one long VBA that will do all 4 things instead of having to do multiple steps manually. (I have more than 200 sheets to do). Any help would be appreciated. Thanks in advance and Merry Christmas.