Created attachment 169264 [details] Example file from Excel with conditions “empty” and “not empty” In Excel it is possible to conditionally format cells that are empty or not empty. Attached file demonstrates that. Calc however does not offer this option on the Conditional Formatting dialog in the “Cell value” condition list. So this is a feature request to extend the list of supported conditions. Steps to reproduce: 1. Open attached file in Calc 2. Go to Format – Conditional – Manage. Actual results: The list displays two “Formula is” type conditional formatting. Expected results: The conditions list should have “Cell value” entries of “is empty” and “is not empty” so that these conditions in XLSX files can be mapped properly. These may be useful on their own too :). It might be necessary to extend ODF as well to accommodate for these. LibreOffice details: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 7eb289c49cc7245ef3001a39be0c15d06bbe875b CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: CL
Created attachment 169265 [details] Screenshot of the original document side by side in Excel and Calc
'Is equal to' "" 'Is not equal to' "" Seems to work fine, but sure having 'empty' and 'not empty' would be fine. +1