Author |
Topic |
|
leopard_pagan
The Oracle
United Kingdom
10898 Posts |
Posted - 24/01/2008 : 13:02:18
|
i am a excel numpty! so laymen's terms need to be used.
i need to set up a stock control sheet for 1,000s of PCB components in my stores. value-case-type-location-quantity-in kit?. columns
in the quantity column id like it to flag up or turn cell red when the quantity drops below 50.
is there a formula for this? |
>^..^< NC29 RR-L with all sorts of custom bits and mods |
|
crm250
Roll on may
United Kingdom
4821 Posts |
Posted - 24/01/2008 : 13:26:29
|
LP i can help you here, use conditional formatting, which simply turns text red ir what ever colour you want it if the number drops below a set figure in the cell or cells. mail it over to me and i can show you if you like |
CRM in "sold a bike" shocker |
|
|
BUGIE
Regular Member
Malta
505 Posts |
Posted - 24/01/2008 : 13:36:49
|
Very easy...
just select all the cells you want with this format, click on the Format menu, Conditional formatting:
in box 1 Choose "Cell value is" and in box 2 "less then". In box 3 type 50 and then Click format and choose the red fill for the cell. Click ok, ok and voila |
|
|
leopard_pagan
The Oracle
United Kingdom
10898 Posts |
Posted - 24/01/2008 : 13:52:11
|
i havnt created the stock yet as i have to go in and stock take it all! finding out if it was possible as i want to make it a feature of the stock file.
at work we use MS 2007 with weird buttons instead of menus. i cant see 'conditional formatting' when i right click>format cells |
>^..^< NC29 RR-L with all sorts of custom bits and mods |
|
|
fontyyy
Senior Member
United Kingdom
2120 Posts |
Posted - 24/01/2008 : 14:08:18
|
Lets play a game shall we? It's called "spot the conditional formatting button";
|
There are two types of people in this world. There are bullies and there are nerds. And there are hot Asian chicks. |
|
|
crm250
Roll on may
United Kingdom
4821 Posts |
Posted - 24/01/2008 : 14:17:53
|
Hmmmm nope still cant see it |
CRM in "sold a bike" shocker |
|
|
Tricky
Familiar Member
247 Posts |
Posted - 24/01/2008 : 14:22:20
|
Whilst on the subject of excel.............
I need a total of figures from different sheets in a workbook.
Eg. I have a VAT figure on sheet1, a VAT figure on sheet 2 and a VAT figure on sheet 3. On sheet 4, the summary sheet, I want a total of the figures in sheet 1,2 & 3. At the moment im doing this manually but how can i get excel to aid me?
Thanks. |
|
|
BUGIE
Regular Member
Malta
505 Posts |
Posted - 24/01/2008 : 14:26:37
|
quote: Originally posted by leopard_pagan
i havnt created the stock yet as i have to go in and stock take it all! finding out if it was possible as i want to make it a feature of the stock file.
at work we use MS 2007 with weird buttons instead of menus. i cant see 'conditional formatting' when i right click>format cells
You won't see it by right clicking on a cell.
If you can't see it (like fonty's page) try right clicking in the empty space on the toolbar (next to the find buttons) and choose the styles toolbar..... I'm just guessing this step as i don't use MS Office 2007 but have a good idea of how office usually works.
Failing that just type conditional formatting in help and it'll show you how to do it. |
|
|
BUGIE
Regular Member
Malta
505 Posts |
Posted - 24/01/2008 : 14:28:41
|
very easy on the cell you want the total just type = and then click on each cell you want in the various cells adding a + after each cell |
|
|
challymo
Settled In Member
United Kingdom
190 Posts |
Posted - 24/01/2008 : 14:32:50
|
Tricky - type "=sum(" into the cell you want your total in then go to your first worksheet and click the cell you want the figure from then go back to summary sheet and type a "," then go to sheet 2 and select the cell there and type another "," on the summary sheet do the same for the third sheet and instead of a "," put a ")" So the writing in the box should look like this "=SUM(Sheet1!C16,Sheet2!B11,Sheet3!B10)" without the speach marks |
300 bikes riding round a small town, even better when the police block the cars for us. VFR400R |
|
|
Tricky
Familiar Member
247 Posts |
Posted - 24/01/2008 : 14:36:56
|
Thanks challymo and bugie. I'll give that a go. |
|
|
leopard_pagan
The Oracle
United Kingdom
10898 Posts |
Posted - 24/01/2008 : 18:56:17
|
the image in a new page is easier to see.
will check tomorrow when back at work. would like to create a working template to show boss/supervisor. got a week or so to work on it. |
>^..^< NC29 RR-L with all sorts of custom bits and mods |
|
|
matman
Familiar Member
United Kingdom
260 Posts |
Posted - 24/01/2008 : 19:08:43
|
lol fontyy that is only in the Office Enterprise Edition though. Sarcy git! |
"It's all fun and games until someone loses an eye... then it's just a game; find the eye!" -M. Marsh
"One death is a tragedy, a million is a statistic" -J. Stalin
"Our successes pass by unnoticed whilst we dwell on our failures" -Anon
"Although it's the early bird that catches the worm, it's the second mouse which gets the cheese." -Flop |
|
|
leopard_pagan
The Oracle
United Kingdom
10898 Posts |
Posted - 25/01/2008 : 12:59:23
|
Thanx all. got a working template now :0)
|
>^..^< NC29 RR-L with all sorts of custom bits and mods |
|
|
AlanH
Senior Member
United Kingdom
1040 Posts |
Posted - 25/01/2008 : 16:32:54
|
quote: Originally posted by BUGIE I'm just guessing this step as i don't use MS Office 2007 but have a good idea of how office usually works
...along the lines of use up all available system resources until it crashes losing the updates you just made to your document ;) |
|
|
BUGIE
Regular Member
Malta
505 Posts |
Posted - 25/01/2008 : 17:27:51
|
lol, something like that :-)
at least they managed to lose the continous blue screens |
|
|
AlanH
Senior Member
United Kingdom
1040 Posts |
Posted - 25/01/2008 : 19:14:31
|
quote: Originally posted by BUGIE
at least they managed to lose the continous blue screens
So you mean that Vista is so bad not even the blue screen of death works ;) |
|
|
leopard_pagan
The Oracle
United Kingdom
10898 Posts |
Posted - 25/01/2008 : 19:30:25
|
hahahahhahahhahahahhahahahhahahhaha
no comment |
>^..^< NC29 RR-L with all sorts of custom bits and mods |
|
|
crm250
Roll on may
United Kingdom
4821 Posts |
Posted - 25/01/2008 : 21:42:41
|
lol vista really is dogsh1t isnt it ?
However on the positive here, anyone worked with 2008 server and done a minimal install ? very very nice its almost novell all over again |
CRM in "sold a bike" shocker |
|
|
|
Topic |
|