Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-28-2006, 07:48 AM
Novice
 
Join Date: Oct 2005
Location: Eagan, MN
Posts: 2
tgorrie
Default I need help with "Conditional Formatting"

I need help with conditional formatting.

A B
40 QTD Actual $3,654,317


41 Qtr. Objective $6,332,604
42 % Attainment QTD 57.7%
43 QTD Par % 53.8%


I'm not sure how to code this.

Cell be B43 varies as the monthly sales increase, Cell A40

Condition 1: Formula Is: If cell B42 is greater then B43 change B42 to green. I understand how to fromat the color.

Condition 2: Formula Is: If cell B42 is between .01% and 5% of B43. Change B42 to yellow.

Condition 3: Formula Is: If cell B42 is less then 5% of B43. Change B42 to Red.

Thanks for your help and input.
Reply With Quote
  #2  
Old 02-28-2006, 12:18 PM
Novice
 
Join Date: Oct 2005
Location: Eagan, MN
Posts: 2
tgorrie
Default Hello?

Is there anyone here that will help?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MYOB and "Item.Send error" Outlook message peter_lambros Outlook 1 12-06-2008 08:24 AM
"IF" "THEN" statements in Macros mfgeng_iss Misc 0 10-04-2007 07:31 AM
Conditional Formatting to Hide Rows or Columns? sczegus Excel 0 09-26-2006 04:17 PM
"open" or "open using" option not availa ccd Outlook 0 09-22-2006 01:23 AM


All times are GMT -7. The time now is 11:41 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft