View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Afia Afia is offline
external usenet poster
 
Posts: 7
Default Conditional formating

I wonder if anyone can help me please

I'm trying to set up conditional formatting for a cell based on data in
range of cells

for example: cell D9 should turn red if E9:Q9 contains letter a

I have been trying using find but no luck so far.
thanks
--
Afia