i had a worksheet with data running into 30,000 rows.i want to color the blank cells according to the item type;
For instance, if the item type is LIBRARY BOOKS;the column D(Reference 1) should not be empty or Blank.It should contain the word LIB.similiar for other types. I want excel to color the blank cell depending upon the item type.can i achieve this using VBA
Thanks in advance.
MOD: this is a follow-on from: http://www.excelforum.com/excel-gene...ank-cells.html
Bookmarks