I am doing my head in and also ruining a perfectly good spreadsheet by trying to edit my conditional formatting settings and would appreciate some help if you can point me in the right direction.
My spreadsheet records readings from my electronic hydrometer/thermometer floating in my beer fermenter. I have used conditional formatting to do the following:
- Column A is the DATE… Column B is the TIME… etc … Column J is the SG READING
- the date in column A is greyed-out if it is the same as the previously recorded date (ie same day)
This has been working fine, for years!
Now, I have tried to add a second condition to the cells in the DATE column (A) so that if the date in column A is the same as a date in another cell, elsewhere on the spreadsheet, which records the date fermentation finished, then the cell in column A will get a red border. The code is like this:
CONDITION 1 If Cell Value Is Equal To: $D$32 Apply Style: BorderRed
where $D$32 is the cell containing the fermentation finished date
and BorderRed is the new style I created
It works if i substitute another style for BorderRed, but I cannot find BorderRed if I go to FORMAT>STYLES>MANAGE STYLES, and if I try to edit on the go by right clicking on the conditional format I seem to be able to edit it but it not only does not work, but also messes up my previous “greyed-out” condition. (I am familiar with the need to list the conditions in the correct order)
I’m not really asking you to solve my coding problem but to tell me how to
- create a new style
- and see it, and choose it, from the drop down list when you program a condition.
When you create a new style - where does it go?
I have read all the material in ASK Libreoffice and watched youtube videos but this aspect of Calc is not explained in a user friendly way.
Many thanks,
James