Highlight entire row based on cell value

Originally Posted by JBeaucaire

Can you post up your macro (don't forget to put code tags around the code) and point out IN the macro where you would want this evaluation to occur? There are many ways to do this and how you're working through your sheet will affect the answer(s).

Please Login or Register  to view this content.

I want it to come right before end sub or in other words I want it to be the last thing to happen. Also in that same section, I am wondering if it finds CRL in column C it will Italicize the entire row independent of its value. Then if it locates in column K anything less than 25,000 if it will highlight the entire row green. Lastly I want it to search column c and k and if it finds crl and less than 100,000 respectively for the entire row to be highlighted green.

Originally Posted by JBeaucaire

It appears the two loops at the end are evaluating the same range. Is the CRL the same first 3 letters?

If so, you can handle all three loops at once by changing the end to something like this:

Please Login or Register  to view this content.

Well the CRL will be searched for once it ahs been placed in the CCY tab so is it ok to leave it in that loop?

Originally Posted by JBeaucaire

No, if the CRL thing is happening elsewhere, you'll have to take it out. But you can still leave the other two loops merged as shown.

Maybe something like this to color all the CRL cell/rows from column C all at once, see if you can get this to work:

Please Login or Register  to view this content.

It says that there is a compile error: Named argument not found - This appears and highlights what I have marked in Red. What should I do from here? Also how do I instead of highlighting CRL, Italicize CRL? Then after Italicizing I want it to search for all CRLs that are less than 100,000 in column K and by doing so highlight that row in green.

Originally Posted by JBeaucaire

That should be Criteria1:=, sorry, forgot the 1.

Well, I forgot about that column K stuff. We'll have to build a loop and check them all.

Please Login or Register  to view this content.

Ok, I ran it and it only highlighted the column headers rather than highlighting those rows where it found CRL. What should I tweak?

Thanks for all of your help thus far. I have been able to accomplish everyting minus highlighting the entire row green if the value in column k is less than or equal to 25000 but greater than 0. Do you know how I could do this in VBA or even using the conditional formatting option in excel 2007?

Originally Posted by JBeaucaire

The code I provided should highlight the rows green, it did in my tests. I don't have 2007 so you'll have to press F1 in Excel and read up on CF in Excel 2007.

It is telling me that: "Out of memory" and the it highlights: If Cells.Value Like "*CRL*" Then

What might be causing this? Also how would I go back into the first tab, position, and delete all the rows that have just been cut?

Originally Posted by JBeaucaire

Ouch, my bad. ONE little letter made the script run out of control. Take that "s" off:

Please Login or Register  to view this content.

Thanks, that was great.

Do you remember the sorting function that you did for me? Well now I am trying to do another one after adding more data. I tried to just reinsert your code further down the macro but when I do it (after I have changed the 995 and 9FF to AM and CL and also changed the end location to the correct tabs the "Select Case Left(cell.Value, 2) is highlighted and said it is a Type mismatch. What shoudl I do to change this so that it will cut adn paste? Also is there a way to include in this code a way to delete all blank rows so that those leftover will all move to the top? Thanks again for your help