Hi there, can anyone help please...I have been making a new spreadsheet to deal with stock keeping, I have 'stock amount' 'target amount' and 'order amount' and I wondered how can I highlight, say in red, when I need to place an order?
Apologies if this is basic, it's just confusing me greatly!
I've attached a single sheet of my stock take if it helps
Many Thanks
Hi Becky,
So when your "stock amount is equal to or less than your "target amount", then turn the "order amount" red? You can do this with conditional formatting. You place the conditional formatting in the cells that you would want to change colors based on when the criteria is true. ie. stock amount is equal to or less than target amount
Last edited by jwright650; 03-24-2011 at 01:28 PM.
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
Hi John,
Thanks ever so much, I'll give it a go
Becky
Hi John,
thanks, that worked fine, I think I understand it now.
A question...rather than putting an amount to highlight when stock goes below in each individual cell, can I put a percentage? and then just copy the cells rule down?
Thanks
Becky
Why not experiment & see?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I tried experimenting and it doesn't seem to read it as a percentage.
Thanks
Attach what you have tried
I'm not sure if you can tell what I've tried, but hope so, sorry if this is basic, I just can't get my head round it!Originally Posted by royUK
It looks like you have a formula for 50%, but of what?
I thought that you were having a column to check against
Edit:added example of what I think you want, see D6
Last edited by royUK; 03-28-2011 at 07:26 AM.
royUK, I like the way you added a screen shot in the comment on that cell...good job!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks