Multiple conditions - Conditional formating

[Fiil]

I want to format the numbers so that Even numbers and Odd numbers have their own style (eg. bold/italic)
while also maintaining the conditions shown in the picture ie. cells greater than 25 red & celles less than 25 green.

Is there any way to achieve this ?

[anon73440385]

Hello,

please see the following sample file: MultipleConditionalFormatting.ods. Should be self explanatory if you look in Format -> Conditional -> Manage...

Note(s)

• Since your conditions are mutual exclusive, their order doesn’t matter. In other cases order may be important.
• You have 2 x 2 conditions. 2 conditions for the value (>25;<=25) and 2 for even or odd, which makes a total of 4 combinations and hence 4 conditions are required.

Hope that helps.

If the answer helped to solve your problem, please click the check mark () next to the answer.

[Fiil]

Thank you!
Thats exactly what i was looking to do, i will upvote, once i’m able to.

[anon73440385]

You don’t need karma to mark it as a correct answer by clicking the check mark () next to the answer (up and down voting is a different thing)