View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Amylou Amylou is offline
external usenet poster
 
Posts: 11
Default 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