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
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
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
Related:
- Conditional formatting with values
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Based on the values in cells b77 ✓ - Excel Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
- How to format windows 7 with keyboard - Guide
3 responses
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
https://ccm.net/forum/affich-735278-conditional-formatting
Let us know if this helps!
Have Fun!
//ark
-Moderator/Contributor
MrCreativity
Posts
2
Registration date
Friday January 17, 2014
Status
Member
Last seen
January 21, 2014
Jan 21, 2014 at 12:57 PM
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
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
