LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formating PaulW Excel Discussion (Misc queries) 1 March 17th 06 03:04 PM
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 05:49 PM
Conditional formating scott45 Excel Worksheet Functions 4 October 4th 05 04:45 PM
Conditional Formating George Excel Worksheet Functions 1 July 26th 05 09:33 PM
Conditional Formating Craley76 Excel Discussion (Misc queries) 3 June 29th 05 08:39 PM


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"