[Solved] Conditional format cell

[AndrewRi]

I tried searching the forum and could not find a solution that works for me. I would like to highlight a cell that contains the max value in that row from a list of nonadjacent cells. I'm using OpenOfice 4.1.6 on Windows 7.

[RusselB]

Use the Conditional Formatting set for "Formula is" and set the formula to be the MAX function with the list of non-adjacent cells being the parameters of the MAX function.

[AndrewRi]

Thanks. I thought I was doing that, but I'm not getting any results. Here is what I tried following formula is MAX($BE221, $BK221,$BQ221,$BW221,$CC221) Any more help is appreciated!

[RusselB]

Replace the commas with semi-colons.
OpenOffice uses semi-colons as parameter separators

[Lupp]

If the formula only returns the value found to be the maximum, the mode of CF must be 'Value is' with 'equal to'. The given example

Code: Select all

MAX($BE221; $BK221;$BQ221;$BW221;$CC221)

is of that type.
With 'Formula is' (which is worded somehow misleading) the formula result is always evaluated as a logical (Boolean) result. The condition is then regarded TRUE if the numeric result is <>0 (different from zero) and FALSE only if the result is 0 (zero).
Having set it this way, the cell style to be overlaid under the condition would always apply if the maximum value found is different from 0. It would not be compared to the content/result in the conditionally formatted cell(s).
To get it as needed with 'Formula is', the base cell of CF, say A221, would need to be compared to the found maximum in the formula cell like in

Code: Select all

$A221=MAX($BE221; $BK221;$BQ221;$BW221;$CC221)

(Also to the OP: There is no version 4.6.1 of Apache OpenOffice. Please check your signature.)

[AndrewRi]

Thanks for feedback on my question and correcting my dyslexic signature. My final solution looked like this $BE221:$CC221=MAX($BE221; $BK221;$BQ221;BW221;$CC221)