Conditional formatting % and KPI target in excel 2003

P

pompeyblue

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top