Adding Percentile Information (Conditional formatting rule)

[DashboardNovice]

I am studying the 6 part lesson on KPI dashboards. On part 3, dealing with Percentile information, the solution on the first tab called 'Dashboard' has conditional formatting rules applied to columns F,H,J,L and N which specifies if the arrows are red or green. I see the conditional format rule for red, but where is the conditional format rule for green?

 

[Debraj]

Hi @DashboardNovice

Please always provide URL, so that we can track.. I hope you are talking regarding this..
http://chandoo.org/wp/2008/09/03/excel-kpi-dashboard-percentile-3/

Here.. RED conditional Format was applied by "old Conditional Format Technique" by Custom Number Format..
Positive;[RED]Negative;Zero;Text
select the cell and check Number Formatting..
Check the technique here..
http://chandoo.org/wp/2011/11/02/a-technique-to-quickly-develop-custom-number-formats/


and Green Number Formating applied by Condtional Formatting..
Select the cell and go to Home > Confitional Formatting > Manage Format.
You can see the Conditional Formatting..

 

[DashboardNovice]

Hi @DashboardNovice

Please always provide URL, so that we can track.. I hope you are talking regarding this..
http://chandoo.org/wp/2008/09/03/excel-kpi-dashboard-percentile-3/

Here.. RED conditional Format was applied by "old Conditional Format Technique" by Custom Number Format..
Positive;[RED]Negative;Zero;Text
select the cell and check Number Formatting..
Check the technique here..
http://chandoo.org/wp/2011/11/02/a-technique-to-quickly-develop-custom-number-formats/


and Green Number Formating applied by Condtional Formatting..
Select the cell and go to Home > Confitional Formatting > Manage Format.
You can see the Conditional Formatting..

Thank you Debraj. I didn't know you can do conditional formatting with a custom number format. Thank you.