Jim_vande_Berg
New Member
- Joined
- Jan 25, 2003
- Messages
- 2
Hello,
With the option Conditional format it is very easy to give cells a different
format based on their data, however it is only possible to set three conditions.
Is there an easy way to e.g. create 5 different formats (in my case 5 different colors) based on data in one column?
The other way around: is it also possible to do some action on cells which have specific colors (e.g. if Red, than count these cells)? is this possible via a standard function within Excel or do I need to use VBA for achieving this.
Thanks!
Jim van de Berg
With the option Conditional format it is very easy to give cells a different
format based on their data, however it is only possible to set three conditions.
Is there an easy way to e.g. create 5 different formats (in my case 5 different colors) based on data in one column?
The other way around: is it also possible to do some action on cells which have specific colors (e.g. if Red, than count these cells)? is this possible via a standard function within Excel or do I need to use VBA for achieving this.
Thanks!
Jim van de Berg