Conditional Format Help
 

How do I write a conditional format that applies to
"=$N$13:$N$22,$N$31:$N$40" where If $L13<$N13 fill the cell RED. This is
what I have in the Format values where this formula is true box:
"="$L13<$N13". But it doesn't work. Any ideas?

Thanks

Conditional Format Help
 

Try getting rid of the quotation marks

"Ayo" wrote:

How do I write a conditional format that applies to
"=$N$13:$N$22,$N$31:$N$40" where If $L13<$N13 fill the cell RED. This is
what I have in the Format values where this formula is true box:
"="$L13<$N13". But it doesn't work. Any ideas?

Thanks