| View previous topic :: View next topic |
| Author |
Message |
velvetpixel
General User
Joined: 13 Oct 2011
Posts: 24
|
 Posted: Wed May 23, 2012 11:37 am Post subject: [Solved] Conditional formating based on SUM |
 |
|
I have two cells A1 and B1 and I would like their backgrounds to be green if the sum of the two cells is less than 24 and red if the sum is more than 24.
How do I achive this?
Last edited by velvetpixel on Wed May 23, 2012 12:03 pm; edited 1 time in total |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed May 23, 2012 11:46 am Post subject: |
|
|
Conditional format with formula ($A1+$B1)<24
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
velvetpixel
General User
Joined: 13 Oct 2011
Posts: 24
|
| Posted: Wed May 23, 2012 12:02 pm Post subject: [SOLVED] |
|
|
| Villeroy wrote: | | Conditional format with formula ($A1+$B1)<24 |
Perfect!
Thank you  |
|
| Back to top |
|
|
|
