Conditional Formating Blanks

[Livin404]

Greetings,

I'm trying to use conditional formatting to highlight any blank cells in a database. I know the formula is something like

=AND(A2="",COUNTA(A2:J$10000))

I want the code to start on A2 and go down only to the last filled cell in Column J and highlight all the blanks. I think " " covers the blank cells, and the COUNTA will look for the fille cells.
I know it's very close, but I'm missing something.

Thank you,

 

[Joe4]

I am not sure the need for the COUNTA portion of your formula.
If you are truly just looking to highlight the empty cells, this should do it:

=A2=""

 

[Fluff]

How about

=AND(A2="",ROWS(A$2:A2)<=COUNTA(J$2:J$10000))

 

[Livin404]

I tried both those formuals without much luck. Does it matter I have

=ODD(ROW())=ROW()

Thank you,

 

[Joe4]

It sounds like maybe you are trying to use more criteria than just looking for blank cells, but I cannot tell what from your explanations (it is very unclear to me).
Are your blank cells really blank, or are they returning something like a single space?

Could you post a sample of your data and show us exactly what you are trying to do?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Fluff]

If you have a formula, or blank cells in col J try

=AND(A2="",ROW()<=LOOKUP(2,1/($J$2:$J$10000<>""),ROW($J$2:$J$10000)))