View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DawnTreader DawnTreader is offline
external usenet poster
 
Posts: 48
Default Conditional Formating =mod($a2,2) = not(mod($a2,2))

i have a quick question

when using this set of formulas in the conditional formatting does it work
on text?

i am trying to alternately highlighting groups of months. for example i have
the month name january in multiple rows, followed by february and so on. i
want each group to hightlight according to the conditional formatting.