Highlight Cells.xlsxHello,
Really new to VBA. Looking for help with highlighting cells in a column based on the value of two differnt cells.
I have a list of values in "A1:A10" as 1,2,3,4,5,6,7,8,9,10
Cell B1 contains the value of 3
Cell C1 contains the value of 7
I would like to highlight all cells in column A that fall between the values in B1 and C1.
I have attached a sample .
Thanks in advance for the help.
Linnie
Hi, welcome to the forum and yes you can use VBA but you can also set a formula and conditionally format based on a simple formula.
I'm on iPad at present so this is untested but if you got to conditional format -> choose CF by formula -> and write a formula like =and($a1> $b$1, $A1<$c$1) and apply to cells a1 to A10 and set the format to the shading you want you should get the same result.
Give it a go. If it doesn't work let me know and I'll fire up the laptop and fix it up for you.
Happy with my advice? Click on the * reputation button below
Pl see attached file.
Hi Crooza,
I have taken entire range ("a:a") like this : j = Sheets("sheet2").Range("a" & Rows.Count).End(xlUp).Row
Please find the code :
If any issues please....
Please Login or Register to view this content.
Or you could try this? I haven't tested please do let me know if there's any issues.
Name your sheet as appropriate
Please Login or Register to view this content.
Sorry posted twice in error - EDIT -
Last edited by jayesh25; 10-26-2014 at 06:28 AM. Reason: Double post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks