Conditional formatting with values
Closed
MrCreativity
Blocked Profile - Jan 21, 2014 at 01:14 PM
- Posts
- 2
- Registration date
- Friday January 17, 2014
- Status
- Member
- Last seen
- January 21, 2014
Blocked Profile - Jan 21, 2014 at 01:14 PM
Related:
- Conditional formatting with values
- Conditional Formatting: Highlight cells based on two values ✓ - Forum - Excel
- Conditional Formatting based on two cell values ✓ - Forum - Excel
- Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
3 replies
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
Jan 21, 2014 at 12:57 PM
- 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
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