VBA code for 5-rule Conditional Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Antonio - 29 May 2008 18:22 GMT

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

Reply to this Message

JW - 29 May 2008 18:38 GMT

> 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/microsoft.public.excel.programming/browse_thread/
thread/23388076916e352/cbe3a1be83ddc6d9#cbe3a1be83ddc6d9

Reply to this Message

Bob Phillips - 29 May 2008 19:22 GMT

... and my last follow-up

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

On May 29, 1:22 pm, Antonio <Anto...@discussions.microsoft.com> 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/microsoft.public.excel.programming/browse_thread/
thread/23388076916e352/cbe3a1be83ddc6d9#cbe3a1be83ddc6d9

Reply to this Message

Antonio - 30 May 2008 14:43 GMT

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 to this Message