derik72090
New Member
- Joined
- Mar 27, 2013
- Messages
- 3
Hi, I'm asked that I create a conditional formatting rule with certain specifications. I'm having a really hard time figuring how to do it. Here are the bullet points.
-Applies to the range A2:C47
-Uses a formula to determine which cells to format based on amounts of $100 or more and that are classified as business expenses. Because this conditional formatting applies to several columns (A, B, and C), you must use mixed cell references in the formula.
-Formats data with a Medium Green fill color and a Green line border using the Outline preset border style.
I'm going to upload a pic of what it is I'm working on. I really hope someone can help me with this as I've been stuck for an hour or so on this and I'm really not sure even where to begin. Please help as soon as you can.
http://i122.photobucket.com/albums/o280/miniviking10/excel4.png
-Applies to the range A2:C47
-Uses a formula to determine which cells to format based on amounts of $100 or more and that are classified as business expenses. Because this conditional formatting applies to several columns (A, B, and C), you must use mixed cell references in the formula.
-Formats data with a Medium Green fill color and a Green line border using the Outline preset border style.
I'm going to upload a pic of what it is I'm working on. I really hope someone can help me with this as I've been stuck for an hour or so on this and I'm really not sure even where to begin. Please help as soon as you can.
http://i122.photobucket.com/albums/o280/miniviking10/excel4.png