with the conditional formating you can format cells in special cases. I attached a sample file. In that file the cells A1, B1 an C1 are formatted with "Cell value" | "between" | "1" | and | "2" and a blue background with white text color.
That means, if the value in the cell is between 1 and 2, PlanMaker formats the cell with a blue background and with white text color. that happens in the cells A1 and A2.
The cell A3 also contains these formating "rules" but the value is 3, so nothing happens here.
- conditional formating.pmd
- (12.5 KiB) Downloaded 174 times
SoftMaker Software GmbH