# Need 2 Formulas

#### Liverpool1959

##### New Member
I do a Financial Spreadsheet for my boss. Lets say A1 is our revenue. B1 is staff cost. C1 is a percentage of cost to revenue. D1 is the difference of C1 to our Goal of 22.5%

Is there a way C1 can turn Red if the Percentage exceeds our Goal of 22.5?
Is there a way D1 can be Red if the difference is over our goal

Example...C1 will be 22.00% (that stays black) D1 would be .5% (we are .5 ahead of target. It stays Black)
But if C1 is 23.00% (we exceeded our goal and I'd like this to be Red) and the D1 would be -.5% (and I want that Red)

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

#### Joe4

You can just use Conditional Formatting on cells C1 and D1:

Conditional Formatting formula on cell C1:
Code:
``=C1>22.5%``
Conditional Formatting formula on cell D1:
Code:
``=D1<0``
and choose your red formatting options.

1,102,135
Messages
5,484,938
Members
407,475
Latest member
Dix_Fix

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...