Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for 5-rule Conditional Format
On May 29, 1:22*pm, Antonio wrote:
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 it’s <=69 it becomes green, if it’s <=79 it becomes yellow, if it’s <=89 it becomes orange and if it’s <=100 it becomes black. Thanks See your prior post. http://groups.google.com/group/micro...e3a1be83ddc6d9 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for 5-rule Conditional Format
.... and my last follow-up
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JW" wrote in message ... On May 29, 1:22 pm, Antonio wrote: 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 it’s <=69 it becomes green, if it’s <=79 it becomes yellow, if it’s <=89 it becomes orange and if it’s <=100 it becomes black. Thanks See your prior post. http://groups.google.com/group/micro...e3a1be83ddc6d9 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanding Conditional Format Rule to entire Column | Excel Discussion (Misc queries) | |||
Copying Conditional Formatting rule | Excel Worksheet Functions | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Copying a range adjacent to Conditional Format - CF Rule adds to P | Excel Discussion (Misc queries) | |||
VBA code for 5-rule Conditional Formating | Excel Programming |