Ask Your Question

MIN Function in calc [closed]

asked 2016-07-30 01:56:21 +0200 gravatar image

updated 2016-07-30 12:42:00 +0200

floris v gravatar image

Used the MIN function to determine the lowest prices. In some of the rows, the lowest price cell color turns green. Yet in other cells it does not. I looked for "options" but couldn't find any. I have copied the working (green) MIN function to a line that was not working to no avail. Would appreciate any assistance.

Thanks, Rich Ramik

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by
close date 2017-02-16 03:03:33.867730


You surely wouldn't expect any cell containing a working call to the MIN function to turn to green backround colour. If this happens, it should be due to a conditional format defined for the cell (a range containing the cell) in advance.
If your "green cells" are not those containing the MIN formula, but those containing the lowest price as entered data, the effect alo must be due to a conditional format. Everything easy for a helper if you provide an example .ods demonstrating the issue.

Lupp gravatar imageLupp ( 2016-07-30 12:31:44 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-07-30 12:36:18 +0200

m.a.riosv gravatar image

You can do it with a conditional format: Menu/Format/Conditional format

image description

edit flag offensive delete link more


Thank you so much for responding. I had completely forgotten about this posting.

As you suggested, it was Conditional Formatting. Not quite sure how I did it, but I now understand the results I am getting.

Thanks again!!!! gravatar ( 2016-12-08 17:50:14 +0200 )edit

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2016-12-08 22:54:39 +0200 )edit

Question Tools

1 follower


Asked: 2016-07-30 01:56:21 +0200

Seen: 2,441 times

Last updated: Jul 30 '16