Are you looking for particular values or just any value?How can I write a formula to highlight rows C-E , if they contain values in column N.
I cannot use 'Conditional Formatting' as I have many values in column N.
=$N1<>""
Did you see my reply? It should do that.Sorry I meant I want to highlight the rows in columns C to E if it contains the value in column N.
=$N[COLOR=#ff0000]3[/COLOR]<>""