AVForums

Our philosophy in our forums, reviews, podcasts and feature videos is to promote audio and visual excellence by gathering and sharing the best information and resources available.

Help

To begin please visit our help section »

Not a Member Yet?

It only takes a minute to start enjoying the benefits of AVForums membership, and it's free!

Member Log in

MS Excel Code ?

Post Reply
Old 07-01-2008, 11:54 AM   #1
Prominent Member
 
samjpullen's Avatar
Join Date: Nov 2004
Location: Keighley, West Yorks
Experience Points:
10,382, Level: 24
Points: 10,382, Level: 24 Points: 10,382, Level: 24 Points: 10,382, Level: 24
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Blog Entries: 2
Thanks: Gave 122, Got 145
Posts: 3,538
MS Excel Code ?

Hi guys and gals, i need a little help with a formula.

I need a formula that will do the following.

Some members of a team have a set target of lets say 10 per day, i need a formula that will show me of they are have made there target or not.


e.g i will input figs and then in another box it will show the same amount but in either Red for not meeting targets and Blue for meeting targets.

So if i input 9 it will show in red text or a red backround and if i input 11 it will show in blue etc.

Anyone able to give me a helping hand

Cheers
MDX
  Quote
Old 07-01-2008, 12:13 PM   #2
Assured Advertiser
 
graham.myers's Avatar
Join Date: Mar 2003
Location: Leeds
Experience Points:
15,557, Level: 30
Points: 15,557, Level: 30 Points: 15,557, Level: 30 Points: 15,557, Level: 30
Activity: 26.9%
Activity: 26.9% Activity: 26.9% Activity: 26.9%
Thanks: Gave 160, Got 557
Posts: 4,459
Re: MS Excel Code ?

That sounds more like a conditional format than a formula and you wont need an extra column

select the cell range where you are inputting the figures. then format > conditional formating.

In there select value is less than and enter 10 in the box. then choose the colour for it. Then select Add>> and add another row which is greater than, and enter 9 in the box and choose the other colour. Hit OK
  Quote
Thanks from:
samjpullen (07-01-2008)
Old 07-01-2008, 1:29 PM   #3
Prominent Member
 
samjpullen's Avatar
Join Date: Nov 2004
Location: Keighley, West Yorks
Experience Points:
10,382, Level: 24
Points: 10,382, Level: 24 Points: 10,382, Level: 24 Points: 10,382, Level: 24
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Blog Entries: 2
Thanks: Gave 122, Got 145
Posts: 3,538
Re: MS Excel Code ?

Cheers

There was me thinking it was going to be some complex formula...
  Quote
Old 07-01-2008, 11:56 PM   #4
Member
 
PmSonic's Avatar
Join Date: Sep 2005
Location: Edinburgh
Experience Points:
3,990, Level: 14
Points: 3,990, Level: 14 Points: 3,990, Level: 14 Points: 3,990, Level: 14
Activity: 1.1%
Activity: 1.1% Activity: 1.1% Activity: 1.1%
Thanks: Gave 127, Got 67
Posts: 706
Re: MS Excel Code ?

I'm a little bored so thought i'd put together an all singing & dancing option for you.

I've used a bit of formula, conditional formatting and added in the weekly percentage that the target is met.
  • B2:B11 is used to set each individuals target
  • Columns with 'Day # Figures' are used to enter individuals daily figures
  • The '+/- Target' columns are locked as they automatically update
  • The 'Overall Weekly Target Met (%)' column is also locked and will automatically update.

The password to un-protect the spreadsheet is 'Target'

Can you tell I cant sleep??
Attached Files
File Type: xls DailyTargets.xls (20.5 KB, 20 views)
  Quote
Post Reply



Thread information and display options
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off