Conditional Formating Formula?
 

I need a formula in conditional formating.
I am CF'ing column M.

If column J contains blank cells.... format .

Conditional Formating Formula?
 

=isblank(j1)
CF:...
---------------------------------------------
"Jman" ...
I need a formula in conditional formating.
I am CF'ing column M.

If column J contains blank cells.... format .

Conditional Formating Formula?
 

hi
may need more detail but.....
formual is.....=IF(J2="",1,0).......format = pukey green. (choose your own.)

post back if that don't work....with more detail.

Regards
FSt1

"Jman" wrote:

I need a formula in conditional formating.
I am CF'ing column M.

If column J contains blank cells.... format .

Conditional Formating Formula?
 

"FSt1" wrote:

hi
may need more detail but.....
formual is.....=IF(J2="",1,0).......format = pukey green. (choose your own.)

post back if that don't work....with more detail.

This worked perfectly.. Thanks.

Regards
FSt1

"Jman" wrote:

I need a formula in conditional formating.
I am CF'ing column M.

If column J contains blank cells.... format .

Conditional Formating Formula?
 

Why bother with =IF(...,1,0) ?
What's wrong with =J2="" ?
--
David Biddulph

"FSt1" wrote in message
...
hi
may need more detail but.....
formual is.....=IF(J2="",1,0).......format = pukey green. (choose your
own.)

post back if that don't work....with more detail.

Regards
FSt1

"Jman" wrote:

I need a formula in conditional formating.
I am CF'ing column M.

If column J contains blank cells.... format .

Conditional Formating Formula?
 

Yeah, this works too.. .Good to know
Thanks.

"David Biddulph" wrote:

Why bother with =IF(...,1,0) ?
What's wrong with =J2="" ?
--
David Biddulph

"FSt1" wrote in message
...
hi
may need more detail but.....
formual is.....=IF(J2="",1,0).......format = pukey green. (choose your
own.)

post back if that don't work....with more detail.

Regards
FSt1

"Jman" wrote:

I need a formula in conditional formating.
I am CF'ing column M.

If column J contains blank cells.... format .