Ask Your Question
0

MIN Function in calc [closed]

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

richramik@yahoo.com 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 richramik@yahoo.com
close date 2017-02-16 03:03:33.867730

Comments

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
0

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

Comments

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!!!!

richramik@yahoo.com gravatar imagerichramik@yahoo.com ( 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

Stats

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

Seen: 2,441 times

Last updated: Jul 30 '16