LinkBack URL
About LinkBacks
In a column, there are 4 option for each cell -
"PAYMENT DUE"
"PAID"
"UNDERPAID BY..."
'OVERPAID BY..."
These are filled in by a formula
I would like to make them 4 different colours but excel only allows 3 options
In a column, there are 4 option for each cell -
"PAYMENT DUE"
"PAID"
"UNDERPAID BY..."
'OVERPAID BY..."
These are filled in by a formula
I would like to make them 4 different colours but excel only allows 3 options
Option 1
Use a macros :
Option 2
The forth option will be white in color....( no formatting )
Shijesh Kumar
http://shijesh.wordpress.com/
How does a macros work?
Try the below code..
Modify it as per your need
Please Login or Register to view this content.
Last edited by Shijesh Kumar; 12-09-2008 at 09:37 AM.
ok will try it
thank you
The Fourth Coloe does not necessarily need to be white. It can be any fill colour. So for your four options I would recommend not to use the macro.The forth option will be white in color....( no formatting )
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
How would I get the fourth colour to not be white?
Format the cell whatever color you want. Conditional formatting will override it.
Entia non sunt multiplicanda sine necessitate
That would mean doing each one?
For a list of several hundred it may take some time?
???
Select all the cells and apply the default color at the same time.
ok well ill have to do that unless there is a way whereby as soon as i type PAYMENT DUE, the box turns red
See the attachment,
it is based on macros..
The way that works is exactly perfect
just my problem is i dont even know what a macro is, so I'm having difficulties applying your function to my document.
i right-clicked on sheet 1 and selected view code and then pasted , then closed it all but nothing happens
I'm sure I must be doing something wrong
Last edited by Tziggy; 12-09-2008 at 03:09 PM.
Did u save the file before closing ALL.
Yeah did that and i changed the column to the column with the staements.
If i write, for e.g PAYMENT DUE in that column it does change to red so in that way it works perfect, but it seems that the problem is that these statements are based on a formula because when i copy the formula from the top cell down to the bottom, the words appear but not the colour coding
also as soon as i copy, i get this
Run time error 13
type mismatch
One thing i didnt mention is that underpaid and overpaid have values next to them i.e UNDERPAID BY R100.00. these values always change for each one
Last edited by Tziggy; 12-09-2008 at 02:46 PM.
The best what I can think in this situation is ..
copy the below code as u did previously..
Place the cursor on the first cell of column where you want the formatting.
And then click on
Tool --> Macros
Then Select xformat and then click on run
Please Login or Register to view this content.
Last edited by Shijesh Kumar; 12-09-2008 at 03:25 PM.
Thanks for the help
THat works fine for everything that is already written in i.e all the PAID turn green, etc but anything that comes in after does not change
also for e.g the top one is paid and turns green,then i drag that formula down and everything becomes green
Yes, I know this
What you need to do is after you copy your formula..
You have to click on Tool --> Macros and select xformat and click Run..
This you have to do each time you copy and change the detail
Otherwise you have to write another macors to automate this...
ok thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks