Conditional Format Help

  • Thread starter Thread starter mjones
  • Start date Start date
M

mjones

Hi All,

How do I say make this cell a format if:

$J583=""

and

$Y583="Invoice"

I think it's SUMIF, but I'm not great at the syntax.

Please help!

Thanks again,

Michele
 
Hi Michele,

I don't know what you mean by "make this cell a format" - can you
elaborate please?

You may well want something like:

=IF(AND($J583="",$Y583="Invoice"), something_if_true,
something_if_false)

but I don't know what the "somethings" should be.

Also, I'm not sure where SUMIF comes into it.

Pete
 
Hi Michele,

I don't know what you mean by "make this cell a format" - can you
elaborate please?

You may well want something like:

=IF(AND($J583="",$Y583="Invoice"), something_if_true,
something_if_false)

but I don't know what the "somethings" should be.

Also, I'm not sure where SUMIF comes into it.

Pete
Click to expand...

I want to make a conditional format to make the cell content turn
orange of J583 is blank and Y583 has the word Invoice in it. Hope
this clears it up; thought the title of my post explained it.
 
Back
Top