I need to conditional format row E (Color Status), Based off of Row B (Credit Limit), C (Credit Used) or D (Available Balance).
Basicly its just a Customer Credit Limit Sheet. When a customer is within 15% of there credit limit a yellow box appears in colomn D, in there row. If there at or above there credit limit a red box appears. All good standing customers will have green boxes.
Its just a quick visual referance that we can update daily.
I would like to use percentages in my formula if possible.
Thanks
Basicly its just a Customer Credit Limit Sheet. When a customer is within 15% of there credit limit a yellow box appears in colomn D, in there row. If there at or above there credit limit a red box appears. All good standing customers will have green boxes.
Its just a quick visual referance that we can update daily.
I would like to use percentages in my formula if possible.
Thanks