|
alright, I am almost done but what I need now is the same thing but for area of work.
so i have:
Name: start time, end time on 1 row and on the 2nd row, i have area of work like Cash, sales, office.
I gave these names a colour in the list I made but when i select them, the colour doesn't follow. Is there a way to make it so that when I pick SALES, the SALES cell and the time cell change to a different colour like red?
-----Added 26/8/2008 at 10 : 59 : 47-----
ok, I feel like an Idiot. I cannot figure it out.
Everywhere on google, they talk about conditional formatting but this is limited to 3 per cell and I have about 10 items in my list that I want to use. If it was only for that, It would be perfect but since i'm limited, I have to look for something else to change my cell colours.
Does anyone know how to do this???
IF(text = sales, cell colour = red, If text = cash, cell colour = green) << this is what I want but I can't find the right syntax or functions to do it....
Last edited by MexicanOnABike; 08-26-2008 at 06:59 PM..
Reason: Automerged Doublepost
|