View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Conditional Formatting query

well, guess you could/should always close off the traffic lights with a
condition 3 for green?

Condition 3, Formula is:
=AND(B3<"",B3-$A$190)
Format Green fill

The check: B3<""
ensures that blank cells will not trigger the CF
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---