LinkBack URL
About LinkBacks
Hello,
In example 1 - I would like B1,C1,D1 to turn a fill color (green), if G1 is greater. than I1
In example 2 - I would like B1,C1,D1 to have no fill (stay the same) if, G1 is less than I1 or even
See attached,
Thank you in advanced,
Tony
Hello,
In example 1 - I would like B1,C1,D1 to turn a fill color (green), if G1 is greater. than I1
In example 2 - I would like B1,C1,D1 to have no fill (stay the same) if, G1 is less than I1 or even
See attached,
Thank you in advanced,
Tony
So are these rules meant to be mutually exclusive? What happens if G1 is greater than I1 AND even?
So far, two rules:
=$G1>$I1
=OR($G1<$I1,ISEVEN($G1))
Last edited by AliGW; 12-19-2018 at 09:44 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Conditional formatting applied to B1:D1 with colour green and formula =$G1>$I1
Click the * to say thanks.
Their can only be 3 out comes:
1. G1 is greater than I1 - in that case fill color the cells green
2. G1 is less than I1 - in that case no fill
3. G1 & I1 are the same - again, no fill
Hopefully I explained that right.
Thanks,
Tony
So, you don't mean even, then, but equal to. So, you need to set up three rules:
=$G1>$I1
=$G1=$I1
=$G1<$I1
EDIT: No, you don't need three rules - you just need one! The other two conditions require no fill, so no rule required.
=$G1>$I1
Last edited by AliGW; 12-19-2018 at 10:02 AM.
Thank you very much, Have a Merry Christmas
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Merry Christmas!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks