View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stuart
 
Posts: n/a
Default Conditional Formatting

i need a formulae that will make conditional formatting do the following.

if column k has a value of 5 or more than column I in the corresponding row
will turn red unless there is a value in the corresponding cell in column J.

how can this be done?

--
Stuart