View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gootroots gootroots is offline
external usenet poster
 
Posts: 28
Default Fill down conditional formatting series

This surly is a simple question with a equally simple answer.

B1:B10 require the following formula:

=B1=True
=B2=True
=B3=True
and so on

when I format B1 and fill down the B1 is still referenced