Hello All,
This is my first post so hopefully I've read all the stickys correctly first.
Anywho:
When the variable "Cell" highlights its cell, in column C, based on the conditions, I would like it
Please Login or Register to view this content.
to highlight the next 14 cells to the right of it on the active cells row.
Any solutions?
Last edited by ultimastryder; 02-22-2010 at 07:00 PM. Reason: Solved
Welcome to the forum.
Why not just use conditional formatting?
=isnumber(search("total", c1))
Entia non sunt multiplicanda sine necessitate
Hello ultimastryder,
Welcome to the Forum!
Use Resize to extend the range like this...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
You don't really want to iterate through every row of col C ...
You should let the OP decide.
Brilliant!!! Thank you Leith, that resolved my issue in a dynamic way.
Shg,
Thank you for your suggestion. Leith's works to where I would not need to enter that formula directly.
Becuase I do not know which cell is going to contain the "total" text. I'm not sure I fully understand how to apply your suggestion.
How do I mark my post SOLVED?
Hello ultimastryder,
I took care of marking the post solved. Here is how you can do it next time...
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks