Thread: Conditional Formatting Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Conditional Formatting Question
try to define the following conditional formatting in A1:

Formula Is-=or(MOD(ROW()-2;2*1)+2<=2,A1=CHAR(89))

then copy
Reply With QuoteReply With Quote