Fill with color if cell is empty

cavajuan

New Member
Joined
Oct 28, 2005
Messages
2
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]
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Assuming you want the format in column A:

Select the column, and for conditional formatting enter
Formula is | =ISBLANK(A1)
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,211,678
Messages
6,103,236
Members
447,848
Latest member
holale

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top