View Single Post
  #3   Report Post  
Jezebel
 
Posts: n/a
Default More that 3 conditions for conditional formating?

Use a second cell to evaluate all your conditions

=IF ( AND ( cond1, cond2, cond3, cond4, ....), TRUE)

Then base your conditional format on that cell.




"Jerry Kinder" wrote in message
...
How do I set more that 3. I need 6 or 8.

I want to have color of cell change if one of the 6 or 8 words appears in
the cell.

Thanks,
Jerry