Hello...
I want to change the colour in a cell depending on the sum of two other cells.
ie
A3=1,B3=1
A4=2,B4=1
A5=1,B5=0
A6=2,B6=4
So i want if
A3+B3>2 THEN C3 TO HAVE GREEN COLOUR
A4+B4>2 THEN C4 TO HAVE GREEN COLOUR
A5+B5>2 THEN C5 TO HAVE GREEN COLOUR
A6+B6>2 THEN C6 TO HAVE GREEN COLOUR
SO IN THE END ONLY C4 AND C6 WILL HAVE GREEN COLOUR.
Is there any formula to do so with conditional formatting?
Last edited by NBVC; 12-04-2008 at 04:03 PM.
Select C3 to the last cell in column C you want to affect...
Go to Format|Conditional Formatting
Select Formula Is from 1st dropdown and enter formula: =A3+B3>2
Click Format and choose Green from the Pattern tab.
Click Ok
Click Ok to finish
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank you for the fast reply but i forgot to write that i have open office and this is not working.any other ideas?
Thanks again.
Well, this is an Excel forum... not OpenOffice...
You can try an OO forum like www.oooforum.org
First try Formula Is taking out the = sign from my formula (e.g. A3+B3>2)... that might work
Thank you my friend and sorry...
did that formula work? just curious.
No,but thanks anyway...
Hmmm...
check out here...for an OO example of Conditional Formatting... http://www.openofficetips.com/2006/0...ing-two-lists/
As I mentioned, the only difference is there is no = sign in front of the formula you apply...
I tried everything,with $,without $,in ( ...),without ( ...),with = and without but nothing worked.
Anyway,thanks again for your time.
FINALLY,IT WAS ($A$1:$A$5)+($B$1:$B$5)>2Originally Posted by NBVC
Maybe this will help someone else.
Thank you again for everything.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks