looking for VBA script or conditional formatting formula that will fill cell in column A yellow if cell in same row of column H equals "BP" and text string in cell in same row of column O contains a value of "3" or "4" or "5" or "6" or "7"
looking for VBA script or conditional formatting formula that will fill cell in column A yellow if cell in same row of column H equals "BP" and text string in cell in same row of column O contains a value of "3" or "4" or "5" or "6" or "7"
Last edited by thrst2no; 02-16-2015 at 06:14 PM. Reason: improver clarification of request
VBA:
Please Login or Register to view this content.
@ waqlrus, not sure that will work. Most of the 3, 4, 5, 6, 7 etc are actually text, not values 03, 04 etc (9/25 are values)
@thrst2no welcome to the forum
Can you stanardize on your entry method in column O?
O 2 08, 09, 10 3 09, 10 4 4 5 7
O2:O3 are text entries, O4:O5 are values.
Searching for 4 (numeric) is not the same as searching for 04 (text)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Correct, FDibbins. I don't think there was a workbook posted when I responded, so I wasn't aware of formatting. I think this will work, it shouldn't matter if O values are text or numbers.
Please Login or Register to view this content.
Thanks for welcoming me to the forum. This is my very first post, so I'm feeling my way thru it.
There is no data entry on my part. Worksheet is an imported .csv file extracted from a db. Will be importing many .csv files and looking to run a macro to format each worksheet for data analysis.
Then how about this?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks