Previous Topic Next Topic

Conditional formatting with values

Closed
MrCreativity
Posts
2
Registration date
Friday January 17, 2014
Status
Member
Last seen
January 21, 2014
 - Jan 17, 2014 at 11:22 AM
 Blocked Profile - Jan 21, 2014 at 01:14 PM
Need some spreadsheet help.

I need the value ($'s) in Cell A to become RED if Cell B is greater than Cell C. Make sense?

So... If my actuals are greater than my budget, I want my remaining budget to be RED (and negative)

Any help would be appreciated.

MrC

3 replies

Answer 1 / 3
Blocked Profile
Jan 17, 2014 at 05:18 PM
Ok, check out this link, and go about half way through the post, I posted a step by step for excel2010.

https://ccm.net/forum/affich-735278-conditional-formatting
Let us know if this helps!

Have Fun!

//ark
-Moderator/Contributor
0
Answer 2 / 3
MrCreativity
Posts
2
Registration date
Friday January 17, 2014
Status
Member
Last seen
January 21, 2014
Jan 21, 2014 at 12:57 PM
Hi! That helped "almost!" :-)

I'm actually trying to post a pic, but I can't...here's the data:
-------
Initiative APPROVED BUDGET ACTUALS REMAINING BUDGET
GROUP 1
PROJECT A $2,250,294 $2,364,168 $113,874
PROJECT B $4,450,000 $3,481,418 $968,582
TOTALS $6,700,294 $5,845,586 $854,708
GROUP 2
PROJECT C $3,007 $3,007 $-
PROJECT D $84,393 $84,752 $359
PROJECT E $8,472 $8,531 $59
PROJECT F $50,005 $41,565 $8,440
PROJECT G $17,425 $15,130 $2,295
TOTALS $163,302 $152,985 $10,317
--------

See REMAINING BUDGET? I need those cells (depending on the data of APPROVED BUDGET AND ACTUALS) to go RED (or whatever color I choose)

So, for PROJECT A...my REMAINING BUDGET ($113,874) should go RED because my ACTUALS ($2,364,168) are higher than my APPROVED BUDGET ($$2,250,294).

The conditions I need are for a total of 3 cells. Make sense? :-/


MrC
0
Answer 3 / 3
Blocked Profile
Jan 21, 2014 at 01:14 PM
OK, the logic is pretty easy. If your remaining budget is negative then color it red.



Take a look at the example.
0