Hello, I need a new help, tried this work with formatting condiconal more is difficult, I wonder if it is possible with VBA, is as follows: From B2 to AB2 have different values larger and smaller than $ 500, like the cells greater than $ 500 would keep the blue background and less than $ 500 would keep the red background, because in the end I have to hide the values, the cells continued to fund its colors.
grateful Leandro
How do you intend to hide the value?
Please Login or Register to view this content.
Last edited by humdingaling; 07-21-2013 at 10:46 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
added extra check if text or 0 = whitePlease Login or Register to view this content.
Humdingaling, nearly perfect, is to adapt? the attached spreadsheet is an example, I need to compare the lines individually with the final values that are in the "AO".
thanks for the help.
Leandro
Pasta1.xlsm
sure not a problem
next time.....best to advise the complete problem first time so everything gets done at once
i see you made some changes to code which is good but I needs to go to 39 to cover until AM
added loop to make it downwards after going across first
based on 2 until last row (which runs off column A)
Please Login or Register to view this content.
Humdingaling, this is exactly what I'm needing, thanks for listening, I'll be more careful in the next for me to do the complete question, grateful, all good.
leandro
sure not a problem
its nothing major just means you get your answer faster
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks