• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Highest & Lowest thr' CF

F

fortune

Member
Numerical values are there in cells A24:N24 with EXCEPTION being there MAY BE some cells within the range A24:N24 which will contain either blank, alphabet(s) or alpha-numericals. (here D24 & H24).
I have applied 6 CFs in each cell. Each CF is meant to generate 1 back ground color so that out of 6 colors; only 1 is generated at a time in every cell depending on the cell's value (having numerical values).

My requirement is: I want to ADD 7th back ground color (in the cell containing numerical value) if the value is HIGHEST in the range & 8th back ground color (in the cell containing numerical value) if the value is LOWEST in the range.

Note: When either of 7th or 8th color would be populated, it should stop processing other 6 CF conditions.

Such more rows (A24:N24) are there running down in the range A24:N200.
I am using Excel 2007.

How to ADD 7th & 8th back ground color (in the cell containing numerical value)?
Thanks for help.


M4

ABCDEFGHIJKLMN
24220.58218.42218.64JSPL218.98217.47217.14Bu218.18216.98217.65217.39217.53210.61
25HighestLowest









In the cell containing numerical value: the CFs are
=AND($DO$2=0,$BB24=1) CF1 i.e. color1=AND($DO$2=0,$BB24=2) CF1 i.e. color2=AND($DO$2=0,$BB24=3) CF1 i.e. color3=AND($DO$2=0,$BB24=4) CF1 i.e. color4=AND($DO$2=0,$BB24=5) CF1 i.e. color5=AND($DO$2=0,$BB24=6) CF1 i.e. color6

Moreover if only 1 cell in the range has numerical value, than 7th & 8th back ground color in the cell is NOT TO BE ADDED.
 
You say you have applied six CFs to one cell and want to apply two more, I assume you realise that the way this CFs are listed will make a huge difference to how the CFs are applied. As soon as a rule is within the requirements you have set it will be applied and other rules will not be run.


.
 
Last edited:
bobhc said:
You say you have applied six CFs to one cell and want to apply two more, I assume you realise that the way this CFs are listed will make a huge difference to how the CFs are applied. As soon as a rule is within the requirements you have set it will be applied and other rules will not be run.


.
Click to expand...
Agreed. The 7th CF will populate FIRST if the value is HIGHEST in the range & then 8th CF will populate SECOND if the value is LOWEST in the range
& THIRD=CF1
FOURTH=CF2 & so on....
 
You must log in or register to reply here.
Back
Top