Conditional Formatting <>""

[howard]

I have a formula in N1:N14 oon sheet "Macro"

=IF(M1>5000000,"Split Cheque advise","")

I have tried o set up CF to highlight the cells that are not blank in the range N1:N14 in yellow, but cannot get it to work

It would be appreciated if someone could asssist me

 

[howard]

I have managed to resolve this

 =AND(N1<>"",NOT(ISBLANK(N1)))

 

[Fluff]

You could just use

=N1<>""

 

[howard]

Thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback.