I want the cell to show just the sum but I also want it to compare that sum to another cell and if true it changes font color?

English
, ,
#1

I want the cell to show just the sum but I also want it to compare that sum to another cell and if true it changes font color?.

B2+C2, IF(B2+C2 >= F1,STYLE(“RED”),STYLE(“BLUE”))

#4

without Doublecalculation:

=B2+C2+STYLE(IF(CURRENT()>F1;"RED";"BLUE"))

Maybe in your Localsettings you have to use , instead of ; as Argumentdelimiter

1 Like
#5

not work, always output = 11/15/14

#2

Here is the formula:

=STYLE(IF(B2+C2>F1,“red”,“blue”))+B2+C2

You must define the styles red and blue additionally.

I recommend to have a look at the free guides which you can download from http://www.libreoffice.org/get-help/documentation/

Tested in LibO 4.2.7.2

#3

This one works the best, yet still it does not change the color of the font for the date.
Is there a way it could do that?
=STYLE(IF(B3+C3>=F1,“RED”,“BLUE”))+B3+C3

#6

ok had to configure a style, which is under format, conditional formatting, I had to create and name my own stile that has red font or blue font, and select the arguments there, now i get the correct output only for future dates, still does not turn blue if it goes to past.

#7

so far =STYLE(IF(B5+C5>=F1,“Red”,“Blue”))+B5+C5 works the best because it at least outputs the date in blue
also =IF((B4+C4)>=F1,STYLE(“Rik”),STYLE(“Rik3”))+B4+C4 does the same thing

#8

Actually go to chrome calc, it is much much more user friendly and has the ability to do these arguments in seconds

#9

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