LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default macro for conditional formatting

Need to apply conditional formatting to cells within
subtotalled rows in lengthy spreadsheets, and would prefer
to do so in a macro, as I will use this solution
frequently. Conditional formatting would turn cells red
for greaterthan values, yellow for lessthan values.
Subtotalling occurs after varying number of rows of data
(~6 - 20), and subtotalled cells occur in columns d-p.

Thanks!
 
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 Formatting & Macro MickyRat Excel Discussion (Misc queries) 0 May 27th 10 10:05 PM
Conditional formatting with a macro Diana Morrison Excel Worksheet Functions 2 December 6th 07 02:58 PM
Conditional Formatting Macro Daren Excel Discussion (Misc queries) 2 June 27th 07 10:58 PM
Conditional Formatting in a Macro Ed Excel Discussion (Misc queries) 2 August 28th 06 11:23 PM
Macro/conditional formatting BigMac Excel Discussion (Misc queries) 1 December 6th 04 11:24 PM


All times are GMT +1. The time now is 11:27 PM.

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

About Us

"It's about Microsoft Excel"