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
Related:
- Conditional formatting with values
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- Conditional format based on another cell containing text - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
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
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
