I’m trying and failing using a "between " values in setting up a conditional function.
I’m trying to get the “stage” column to be filled in based on the value in column C and E.
Is using a formula better than using “between” conditional values?
How can I set this up “correctly”?
Thanks ahead for any suggestions or help.
BP Sample Chart.ods (40.5 KB)
LO version: 25.8.3.2 (X86_64)
OS: Ubuntu 25.10
Possible answer:
BP Sample Chart_LeroyG.ods (34.9 KB)
OR($Sheet1.$C10>$Sheet1.$G$7,$Sheet1.$E10>$Sheet1.$H$7)EDIT:
Values added to column G and H are used as threshold in the formula of the conditional formatting (see the $G$7, etc.).
To extend the code (N, E, 1, 2, C), add a number to each cell.
LeRoy, thanks for the help. But it is still not working for me.
First of all, I do not understand your statement “To extend the code (N, E, 1, 2, C), add a number to each cell.” That may be my problem as I increase my log file.
As you can see the one I added does not letter wise, define the level “N”.
What am I still not getting.
As you can tell I’m really new at this, going on 79 and still “learning” new things. I really appreciate your help, thank you.
I attached the file that is failing (BP Still Fails Chart)
BP Still Fails Chart.ods (51.5 KB)
Click on the last “coded” cell (D67 in your sample file), hold Ctrl and double-click on the fill handle (the little square in the lower right corner), to fill down.
Thank you for the quick reply, I got it now. I’m very happy with the layout. 