Fill with color if cell is empty

[cavajuan]

Hi, this is my first time here and hopefullly someone can help me.

I have a worksheet with 18,000 records and in one of the columns there are records that are empty.

My question is how can I color those cell that are empty in the column so it is easy for me to identify them.

I think I need to use Conditional Formating but I don't know how to write the code.

Thank you. [/i][/b]

 

[Von Pookie]

Assuming you want the format in column A:

Select the column, and for conditional formatting enter
Formula is | =ISBLANK(A1)

 

[cavajuan]

Thanks Van, the code is right. However I am working with a text file I imported from Note Pad and even tough the cells show empty the color didn't change.

I press F2 to see if there are spaces but there are not. Then I hit enter and the color change. It is strange.

I think I will write a code next to the column so that every time LOOK comes up I can identify the cell I need to work.

= if (A1="", "LOOK","")

Thanks for your help any ways.