ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional formatting % and KPI target in excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/251288-conditional-formatting-%25-kpi-target-excel-2003-a.html)

pompeyblue

Conditional formatting % and KPI target in excel 2003
 
I need a little expertise to help me with using conditional format for total
order % before and after 3pm target time. Including if bothe cells are 0%.

Before 3 target is 62.5% or above = green, below 62.49% = red

After 3 target is 62.5 % or above = red, 62.49% or below = green

if both before 3 and after 3 are = 0% then = red

Many thanks for any simplistic help.


All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com