Description: I wish to use conditional formatting to help provide myself with useful information at a glance e.g. it has been at least 30 days since the cell's value. Steps to Reproduce: TODAY() === 2023-10-29 1. Open a new spreadsheet 2. Fill a column with three dates 2023-10-29 2023-11-20 2023-11-30 3. Select the column and then Format -> Conditional -> Manage -> Add -> All cells 4. Minimum -> Formula: value < TODAY() + 15. Lime 5. Middle -> Formula: value >= TODAY() + 15. Yellow 6. Middle -> Formula: value >= TODAY() + 30. RED Actual Results: RED RED RED Expected Results: Lime Yellow RED This should ideally be the case regardless if I am using "All cells", "Cell value", "Formula is". If I could customize "Date is", that would also be useful for this particular use case. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-NZ (en_NZ); UI: en-US Calc: CL threaded
Created attachment 190487 [details] TEST DATA
Created attachment 190494 [details] Document with four CF-Conditions
Hallo James Your Assumtion about CF: Colorscale is completly wrong! you need →Format→Condidional Format→ Condition: 1. (for empty Cells) Cellvalue equal to "" →→→Standard 2. Cellvalue less then TODAY()+15 →→→Lime 3. Cellvalue less then TODAY()+30 →→→yellow 4. Cellvalue greater|equal TODAY()+30 →→→red