Conditional Format question

[redspanna]

Hi all

What formula would I add into the NEW RULE > USE A FORMULA TO DETERMINE WHICH CELLS TO FORMAT box
to highlight certain cells in row IF the cell in column A is NOT blank but the cell in column M is

any help appreciated

 

[Marcelo Branco]

What cells do you want to format when A<>"" AND M=""?

M.

 

[redspanna]

It would be cells A:M

 

[Fluff]

Try
=AND($A1<>"",$M1="")

Change row numbers to reflect first row in the applies to range

 

[redspanna]

That's perfect, thank you

 

[Fluff]

You're welcome & thanks for the feedback