Thread: Conditional format based on criteria
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Conditional format based on criteria
Errata:

Line
=AND($B15,$C260,$D260)

should read as:
=AND($B15,$C160,$D160)

Then just select the entire row1 (your col headers),
and delete the CF applied from that row
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote