Hi all,
I am new to Libre, its what i have installed on my work laptop.
I am trying to create a spreadsheet that will automatically change the background colour of a cell if i enter a Y or N, so for the Y i want it to be green and for the N i want it to be red.
I have tried following tutorials and nothing is working, the cells dont change, so clearly doing something wrong.
Can someone give me an idiots step by step please lol
I have tried following tutorials
This doesn’t tell any potential reader of your question, what you have tried exactly. Please assure to explain what you did, which tutorial you are referring to and where it failed (a sample file of the result of your efforts is often the key to an answer)
Hello,
the buzzword here is “Conditional Formatting”.
Step1 - Preparation of required styles for Conditional Formatting
Conditional Formatting requires a style to be applied based on one (or more) condition (See Step 2). Hence we need to create cell styles for a green background and one for a red background. This is what this step is about:
Styles -> Manage Styles (or use F11)New and then tab Organizer
BGgreen for a green background - but it is up to you)Background, click button color and select your desired green colorOK
Repeat the same thing for red colored background (e.g. BGred)
Step2 - Define the Conditional Formatting
(This example assumes that Y or N should be input in column A, starting in row 2 (row 1 should be a header line with no data input)
A2
Format -> Conditional -> Condition"Y" into field and Apply Style select BGgreen"N" into field and Apply Style select BGredA2:A1048576
See the following sample file: ConditionalFormatting-Yes-No.ods
Hope that helps.
Thank you 
That worked perfectly, i think the error i was making was not putting “” either side of the letter as this was how i was trying before, just with Y or N
Yes - and my versions tells this:
