View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Antonio Antonio is offline
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.