Conditional formatting formula help
Hi Excellers,
I have a formula based total in I3
In E3 I have a formula based total too.
I need to conditional format the I3. Red if greater than or equal to 25% of E3, Amber 10% to 24% of E3, Green if 0% to 9%.
I do not have the space to create a separate percentage column.
Thank you in advance.
select the range you want to apply to (say from A2:A10)
go to Home tab -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=$I3>=$H3*0%
format green
repeat steps for amber and red:
=$I3>=$H3*10%
=$I3>=$H3*25%
the sequence must be as above. otherwise, you can also ignore the sequence if you do a range.
=AND($I3>=$H3*0%,$I3<$H3*10%)
=AND($I3>=$H3*10%,$I3<$H3*25%)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks that workedyour a star
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks