ISBLANK and equal formula

[wizzan1]

Hey!

I was hoping anyone could help me out with this one, I'm new to excel.

I want this formula to be true in conditional formatting;

R10C16 = blank
R72C16=212

if those two are true I would like to format a cell.

Thanks!

[6StringJazzer]

Use the option that says "Use a formula to determine...."

Please Login or Register  to view this content.

Do you have the R1C1 format turned on? I almost never see people do that.

ETA: I just looked at your other thread. You will need to use ";" instead of "," for your localization.

[wizzan1]

Use the option that says "Use a formula to determine...."

Please Login or Register  to view this content.

Do you have the R1C1 format turned on? I almost never see people do that.

ETA: I just looked at your other thread. You will need to use ";" instead of "," for your localization.

Thanks alot! works like a charm.
Yeah It seems like i have R1C1 format on. I'm configuring some stuff at work and they do have it on. Are there any disadvantages having it turned on?

[6StringJazzer]

No disadvantages at all, just that almost everybody uses the default A1 format.