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

Sorry, but it hasn't worked. It changes the color of the cell at the first
time, but if the reference value changes it won't change the color of the
cell accordingly.

The structure is: B1 changes its color according to a value that's present
in A1 (1 to 5).

Values in A1 change according to an If function related to values in C1. So,
whenever C1 changes, A1 values change as well, and I expected the color of B1
to change accordingly, but that's not happening. Don't know how to solve it.
 
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 07:04 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"