Libre Office 188.8.131.52, English, Calc
Win7 Ultimate, English
I am creating a “Work Status” spreadsheet to easily show the current position of any unit being worked on via a unique color. The sheet is arranged to show the stages of work completion in columns and the unit identification in rows. There are 10 stages of completion.
The cell in each “stage of completion” is either blank, or has a date. I have created “styles” with the corresponding background color for each stage. The styles are named by column ID (K,M etc). My intent is to adopt the color of the cell closest to completion in all the preceding cells on that row.
I have tried conditional formatting in cell J2 (preceding cells contain unit information) with:
“Formula is” IF(K2<>""
“Apply style” K
“Cell Range” B2:J2.
The problem I have is: IF the referenced cells are not blank AND have another conditional format style set, they do not change to the new one. I have tried both multiple conditions per cell and one condition per cell (keeping the Range of Cells constant for that cell) but still have the same problem.
Using “NOT NULL” might be the wrong formula so I have tried to find a list of “working” examples of functions but have so far failed.
Is there a way to insert a Style or Color from within a formula. I found Color in the function list but not a very good explanation of it’s use. I don’t know if the R G B colors are in hex or decimal. (Tried both, both failed, probably because of my ignorance Oh Well)
ANY assistance will be GREATLY appreciated.
Thanks in advance.
Thanks for the suggestion to upload.
SHEET1 is what I have, SHEET2 is what I would like to have.