LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 134
Default VBA code for 5-rule Conditional Format

Would anyone have a VBA code for a macro that changes the color of a cell
according to 5 different rules? If the cell is <=59 the cell becomes blue,
if its <=69 it becomes green, if its <=79 it becomes yellow, if its <=89
it becomes orange and if its <=100 it becomes black.
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
Expanding Conditional Format Rule to entire Column KKD Excel Discussion (Misc queries) 1 May 27th 09 07:58 PM
Copying Conditional Formatting rule Hartmut \(Harry\) Kloppert Excel Worksheet Functions 1 April 21st 09 02:28 AM
Code to conditional format all black after date specified in code? wx4usa Excel Discussion (Misc queries) 3 December 26th 08 07:06 PM
Copying a range adjacent to Conditional Format - CF Rule adds to P DJH71 Excel Discussion (Misc queries) 0 June 4th 08 07:49 PM
VBA code for 5-rule Conditional Formating Antonio Excel Programming 10 June 2nd 08 12:19 AM


All times are GMT +1. The time now is 06:28 AM.

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"