Conditional formatting not coloring correct cells

English
, ,
#1

I downloaded this sample budget calc document from opensource.com : Using LibreOffice for your open source budgeting tool | Opensource.com

I now want to improve it be highlighting the cells with red if I am over my budget and highlighting green if I am below my budget. I attempted to complete this task by using the conditional formatting tool under Format > Conditional > Condition. I then selected the options that would achieve the results I’m looking for. However, the result is instead that any cell with a non-zero value is highlighted red whether it is below my budget or not.

edit 1:

I am using Mac OS and the file is saved in ods format.

The equation I use is pictured here (B14 is where my max budget is saved):

image description
image description1296×1106 44.8 KB

#2
  • Which operating system and which LibreOffice version do you use?
  • In which file format have you saved?
#3

Edit your question and include the formula you used in Conditional Formatting.

#4

Updated the post

#5

Try to set an ABSOLUTE address for B14

ABSOLUTE address.png

In this case, each cell in the range C14: O14 will be compared with this value. At present, C14 is compared with B4, the rest of the cells are compared with C4, D4, E4, etc.

#6

Okay, it’s working now. Thanks :slight_smile:

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.