Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Perform action if value in cell - conditional VB stmt
Hello,
First, thank everyone for your help to me previously. I've run into a need repeatedly that I'm sure a VB code will solve. I have a spreadsheet that contains columns A to J and rows 1 to 100. The word "Paid" appears sometimes, not always, in column H of my data. I need a code to repeatedly look for every occurrance of "Paid" in column H and do the following til the end: a) highlight the *row* in my data (not the entire row in Excel beyond my data) that contains the word "Paid" in yellow (I don't want to use conditional formatting in this instance if it applies) b) insert 2 rows underneath the row that contains "Paid" & highlight those rows gray Thank you very much for your help. Studebaker |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
%1 appears in "Application used to perform action" when trying to edit a file type | Excel Worksheet Functions | |||
Perform a "Conditional Substitute/Replace" | Excel Worksheet Functions | |||
If stmt and assigning a value to another cell | Excel Worksheet Functions | |||
How do I perform a contains function for a specific cell? | Excel Worksheet Functions | |||
can you perform a character count per cell with numbers? | Excel Discussion (Misc queries) |