ods LibreOffice hero wanted for help.

[100kwh-hunter]

No atm i am making pretty large .ods(.xls) files.
I can by accident make a list on a other page and let them look for that cell specifications.
Ofcourse i can also make some formulas, even from one tab to the other, but that is it.
This program can do so much more.

Q1 can someone help me with this "for dummies"?

Q2 i would like to color the complete line yellow if a cell is after capacity test between 60soh and 80 soh
I would like to color the complete line red if a cell is below 50% soh.
I would like that LibreOffice does this automatically, instead of me doing manually....

145​

icr18650-26h​

2600​

1506​

57,92%​

7-16 ohm​

61,8​

398/406​

​

19-08-23​

​

02-09-23​

​

​

146​

icr18650-26h​

2600​

1923​

73,96%​

7-16 ohm​

61,3​

398/405​

​

19-08-23​

​

02-09-23​

​

​

147​

icr18650-26h​

2600​

2146​

82,54%​

7-16 ohm​

59​

411/408​

​

19-08-23​

​

02-09-23​

​

​

148​

icr18650-26h​

2600​

1968​

75,69%​

7-16 ohm​

57,8​

402/406​

​

19-08-23​

​

02-09-23​

​

​

149​

icr18650-26h​

2600​

2031​

78,12%​

7-16 ohm​

58,4​

398/405​

​

19-08-23​

​

02-09-23​

​

​

150​

icr18650-26h​

2600​

2207​

84,88%​

7-16 ohm​

53​

411/411​

​

19-08-23​

​

02-09-23​

​

​

151​

cgr18650cg​

2250​

143​

6,36%​

40-50 ohm​

62​

​

​

​

​

​

​

​

152​

cgr18650cg​

2250​

1730​

76,89%​

40-50 ohm​

48,8​

​

​

​

​

​

​

​

153​

cgr18650cg​

2250​

362​

16,09%​

40-50 ohm​

64,4​

​

​

​

​

​

​

​

154​

cgr18650cg​

2250​

1612​

71,64%​

40-50 ohm​

49,6​

​

​

​

​

​

​

​

155​

cgr18650cg​

2250​

1668​

74,13%​

40-50 ohm​

48,4​

​

​

​

​

​

​

​

156​

cgr18650cg​

2250​

494​

21,96%​

40-50 ohm​

69,1​

​

​

​

​

​

​

​

157​

cgr18650cg​

2250​

1236​

54,93%​

40-50 ohm​

52​

​

​

​

​

​

​

​

158​

cgr18650cg​

2250​

1482​

65,87%​

40-50 ohm​

51,7​

​

​

​

​

​

​

​

159​

cgr18650cg​

2250​

1641​

72,93%​

40-50 ohm​

45,5​

​

​

​

​

​

​

​

160​

cgr18650cg​

2250​

1659​

73,73%​

40-50 ohm​

47,5​

​

​

​

​

​

​

​

161​

cgr18650cg​

2250​

399​

17,73%​

40-50 ohm​

62,3​

met soldeer​

​

​

​

​

​

​

162​

cgr18650cg​

2250​

998​

44,36%​

40-50 ohm​

57​

met soldeer​

​

​

​

​

​

​

163​

cgr18650cg​

2250​

563​

25,02%​

40-50 ohm​

62​

met soldeer​

en deuken​

​

​

​

​

​

164​

cgr18650cg​

2250​

1745​

77,56%​

40-50 ohm​

55,7​

​

​

​

​

​

​

​

165​

cgr18650cg​

2250​

1768​

78,58%​

40-50 ohm​

56,1​

​

​

​

​

​

​

​

166​

cgr18650cg​

2250​

1681​

74,71%​

40-50 ohm​

55,2​

​

​

​

​

​

​

​

171​

cgr18650cg​

2250​

​

0,00%​

40-50 ohm​

56​

​

​

​

​

​

​

​

.......a..................b...............................c...............d..................e....................f...........................g

So if column "e" row 166 his outcome in that cell is 74% i would like to let the program color it yellow.

I hope this is possible.
Many thanks in advance, kind regards Igor

Ps to bad i cannot copy/paste with colors only "dry" text.

 

[Korishan]

It's called Conditional Formatting. You'll need to put the formula in the dialog box settings

 

[100kwh-hunter]

I will try this, this afternoon.
Thanks!