Conditional formating with formulas

  • Thread starter Thread starter craigproudfoot
  • Start date Start date
C

craigproudfoot

HELP ME!!!!!!!
I have a document that compares budgets(column F) to actuals (column
H). I want to set up conditional formatting with 3 conditions and the
colour/ formatting to show on the H column.

0-79% of budget = red field
80-99% of budget = orange field
100% + of budget achieved = green field

What fomulas would I need for each and which order should I use these
as I have read that this is also important.....

Any help at all would be brilliant - I have been literally trying to
work this out all day !!!!!

Thanks very much
Laura:confused:
 
Laura,
In cell H2

Condition 1 - Formula is:

H2<=79%*F2

Condition 2 - Formula is:

(H2<=99%*F2)*(H2>79%*F2)

Condition 3 - Cell Value is: (greater then or equal to)

F2

This worked for me.

Cheers,

Stev
 
CF1: =AND($F2<>"",$H2<>"",($H2/$F2)<80%)
CF2: =AND($F2<>"",$H2<>"",($H2/$F2)<100%)
CF3: =AND($F2<>"",$H2<>"",($H2/$F2)>=100%)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"craigproudfoot"
 
THANK YOU SO MUCH - brilliant, absolutley spot on - works like a dream!

Really appreciate your help, you are a total star

Thank you
Laura
 
Back
Top