Color Blank cells

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 normal worksheet functions or VBA is necessary.thanks in advance.

Use Conditional Formating

hmmmmmmmmmmmm.i feel its not the right choice.I want to color the blank cells based on ITEM TYPE.

with your list of unique items in say col k
select range d1:g? and apply conditiomal format
formula is
=AND($B2=$K$1,D2="")
then for next item
=AND($B2=$K$2,D2="")
note you only get 3 conditions unless you are using 2007

now, i had more item types in my data. what to do then. Any VBA work around friends.

Get Around Excels 3 Criteria Limit in Conditional Formatting

This is a double post. ExcelKeechak, please read the forum rules again.

http://www.excelforum.com/excel-prog...ank-cells.html

not really - this did not start as a VBA post - the other is in the programming forum, I do believe however this thread should be marked by OP as solved.

Sorry if it hurts anybody. But i want the solution in both methods. What is wrong in it.???The solutions does not fulfill my requirements.

Originally Posted by excelkeechak

Sorry if it hurts anybody. But i want the solution in both methods. What is wrong in it.???The solutions does not fulfill my requirements.

You still have not supplied a better example, like I asked you in your other thread.
Why ask for help, but then refuse to help us help you?

i had provided the original sheet as example.tell me how to color blanks cells for the respective account heads.

Originally Posted by excelkeechak

i had provided the original sheet as example.tell me how to color blanks cells for the respective account heads.

Okay, I see what is going on now, will look and get back to you on this, thanks

It took a while(many hours actually), as I was trying to use Autofilter to do this, and I couldn't get it to work.

I ended up using a few loops and some prepping has to be done on the Worksheet as well, as you will we on Column O:R.

It might not have been so difficult, but some rows will be completely blank, and just the columns for the specific heading need to be colored.

Column O enter the Account heads to look for
Column P enter the Starting column for that heading
Column Q enter the Ending column for that heading
Column R Select a color you want for that heading

Thanks very much Mr.davesexcel.This is exactly what i want.how do i modify the code so that the same code works for some other account heads & other dependent columns.thanks in advance.

Here is an updated workbook, the heading data is now in the other sheet, just add to the list in sheet,"Headings", don't forget start columns ,end columns, and the color you want.
Column A =1, Column G = 7.