Excel conditional formatting priority and stopIfTrue cascade. Reconstruct the fu...

{ "body": { "artifact": { "conditionalFormatting": { "claim": null, "data": { "cells": [ { "base_style": { "fill_color": "FFFFFF", "font_bold": false, "font_color": "000000", "font_italic": false, "number_format": "General" }, "column": 1, "id": "a", "row": 1, "type": "number", "value": -4 } ], "rules": [ { "condition": { "op": "equal", "values": [ 0 ] }, "priority": 1, "ranges": [ [ 2, 2, 3, 3 ] ], "stop_if_true": true, "style": { "fill_color": "FF0000", "font_bold": true, "font_color": null, "font_italic": null, "number_format": null } }, { "condition": { "op": "greaterThan", "values": [ -100 ] }, "priority": 3, "ranges": [ [ 1, 1, 1, 1 ] ], "stop_if_true": false, "style": { "fill_color": null, "font_bold": false, "font_color": null, "font_italic": true, "number_format": null } } ] } } } }, "bodyType": "json", "method": "POST", "type": "http" }

{ "example": { "billable": true, "findings": [ { "confidence": 1, "evidence": [ { "page_indices": [], "page_url": null, "pattern": "spreadsheet-conditional-dxf-priority-stopiftrue-property-cascade_scoped_evidence", "type": "artifact" } ], "limits": [ "Complete bounded supplied artifact only. computed uses 6dp numbers; full result SHA256 uses UTF16-sorted compact JSON, scalar Unicode unchanged and -0=0. No external lookup, trust/identity or legal verdict." ], "module": "spreadsheet-conditional-dxf-priority-stopiftrue-property-cascade", "state": "observed", "value": { "claim_matches": false, "computed": { "cells": [ { "effective_style": { "fill_color": "FFFFFF", "font_bold": false, "font_color": "000000", "font_italic": true, "number_format": "General" }, "id": "a", "matched_priorities": [ 3 ], "property_sources": [ { "priority": 3, "property": "font_bold" }, { "priority": 3, "property": "font_italic" }, { "priority": null, "property": "font_color" }, { "priority": null, "property": "fill_color" }, { "priority": null, "property": "number_format" } ], "stopped_by": null } ] }, "computed_sha256": "d1d86c831828fc606827d08118f9fb0fef0bff0b0d5bb6748f94830ba98c361c" }, "warnings": [] } ], "known_count": 1, "scope": { "contact_values_returned": false, "network": false, "supplied_artifact_only": true }, "warnings": [] }, "type": "json" }