View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scully Scully is offline
external usenet poster
 
Posts: 1
Default Conditional Formatting Text based on a formula

I have got a range of cells 'lets as A1 to F6' all with text in them. I know
it is possible to highlight cells based on the text that they have in them,
however i only what it to highlight the text when another cell 'g2' is
greater than a certain number eg '2'. Is it possible to do this?

Thanks in advance.
Craig
--
I'm not mad the voices in my head keep telling me so!