if i want to highlight a cell range that is always highlighted, when text is inputted how do i do that using calc ?
so for example:
A2 requires data input in cells B2 D2 F2
C4 requires data input in cells B4 F4
etc that is the question. how do i do that, so the moment, A2 Data is added ie ‘A’ it colour codes cells ‘B2’ ‘D2’ ‘F2’ ? is that possible ?
test example.ods (11.8 KB)
