Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2006, 07:48 AM
tgorrie tgorrie is offline
Novice
I need help with "Conditional Formatting"
 
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
tgorrie tgorrie is offline
Novice
I need help with "Conditional Formatting"
 
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
I need help with "Conditional Formatting" 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft