[Solved] Multiple Conditional Formatting

[CHRISNEESE]

im formatting background colors in column F to red if 31/41RN dispos or green if 31RA dispo, those are the three i have formatted so far, the onl problem is that open office with onl let me do 3 conditions, therefore i can't add more dispos, please tell me how i can add more to one condition, so far i just use if value is equal to "31RA" and then changed the new stle

[Zizi64]

The conditional formatting function of the LibreOffice has more than three condition.

...or you can achieve your own "conditional formatting" function by the usage STYLE() function in your formula.

[CHRISNEESE]

So you are saying to change to formula and write with an "if" statement and change style that way?

I'm very new at this, please explain in detail
I understand the concept of the formulas, i just don't have a much practice with it, im looking to make any text value with the value of (41rx,41rx,31rj,41rj,41rn,31rn) turn red , my dispostitong(31..41...) are in column F

[Zizi64]

So you are saying to change to formula and write with an "if" statement and change style that way?

Yes.

Can you upload your example file with some data, and formula, and some instructions for the format properties?

[keme]

Incidently, a formula used in conditional formatting can also use the STYLE() function to apply a style to the cell. This separates content from formatting, so a formula is not muddied by the STYLE() part, and also you can use this for data entry cells, where you don't have a cell formula to insert STYLE() into.

See attached file. Numbers 1-5 in A1 will change frame colour for B1.

In LibreOffice you can add more than 3 conditions, and also use some other formatting functions. I have not tested how those options translate to other spreadsheet applications (such as OpenOffice Calc and MS Excel). There may be portability issues.

[CHRISNEESE]

I need the values in the disposition column to be green when( 31RA, 31RR, 31RI, 41RA, 41RI, 41RR) And to be red when (4100,41RX, 41RJ, 0042, 31RX, 31RJ, 31RN, 41RN)

[coray80]

Create a table somewhere off to the side or on another sheet and use the COUNTIF function as per the attached as you really only need two conditional formats.

[CHRISNEESE]

I see that the formula works on your demo, but when I try to copy over it does not work, please paste formula here?
i would like to know how to add in more values on my own so that i can go through the list and just add all of them

[keme]

The formulas are in the conditional formatting, but they depend on data in columns L and M.

Inspect the conditional formatting for the coloured cells in column G. Try to add new codes in columns L and M, and use the codes in column G.

Pasting formulas here will not help you. You need to see how they work together with source data (codesets) in the spreadsheet.

[CHRISNEESE]

Oh! it works, i wouldn't prefer to have random texts out like that, but it definitely worked and i moved those was out of my view, thank you!!

p.s. I missed it the first time i looked at your spread i didnt have it in full frame view

[keme]

If you want the codesets out of view, you can hide the columns (right click the column letters). Even better for a "production sheet" would be to have the codes in a separate sheet. That reduces the risk of inadvertenly deleting some codes (by removing spreadsheet rows). You can also hide sheets from view (right click the sheet tab).

Having it all visible in one sheet, like coray80 did, makes it easier to grasp the concept.

[CHRISNEESE]

TRANSFER PICTURE PLEASE IGNORE