Thread: Conditional Formatting - Can I select a select with Conditional Formatting?
View Single Post
  #6   Report Post  
Max
 
Posts: n/a
Default Conditional Formatting - Can I select a select with Conditional Formatting?
=SUMPRODUCT(COUNTIF($G$2:$K$16,H18:V18))=15

Or, slightly shorter using SUM:
=SUM(COUNTIF($G$2:$K$16,H18:V18))=15
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--


Reply With QuoteReply With Quote