Conditional Formatting. Highlight if two columns > 0

[Seahorse]

I want to hightlight a number if closed date is populated (the number is a priority and clearly if it's closed it shouldn't be populated). Column A is the Priority, column C is the closure date. So what I want to do is highlight a row if if column A is >0 and column C >0

=AND($A3=">0",$C3=">0")

I am assuming my syntax is wrong, but this looks ok checking online examples and a working COUNTIF formula?

 

[Somendra Misra]

Hi Seahorse,

Use below formula:
=AND($A3>0,$C3>0)

Regards,

 

[Seahorse]

Thank you Sir, does the job

 

[ThrottleWorks]

Hi Seahorse, I am sure you must be knowing this. Just incase..

Your formula is searching a string rather than a number.
Use of "" for criteria >0 has turned this in a string.

The formula you were using will show true if A3 and C3 has string value: >0.
It is not checking the numeric value 0

Good night.

 

[Somendra Misra]

@Seahorse

You are Welcome.

@ThrottleWorks

Well said.

Regards,

 

[Seahorse]

Hi Seahorse, I am sure you must be knowing this. Just incase..

Your formula is searching a string rather than a number.
Use of "" for criteria >0 has turned this in a string.

The formula you were using will show true if A3 and C3 has string value: >0.
It is not checking the numeric value 0

Good night.

Doh! been staring at the screen too much