I would like to use conditional formating in the simplest possible way.
Specifically, I have the following two columns: (min,value) , and I don't want to add any new column.
In principle, I would like the following formatting:
violation when value smaller than min-eps : show min in red background
hit when value in range [min-eps,min+eps] : show min in blue background
valid when min+eps smaller than value : show min in white background
where eps is a very small constant that I use to account for rounding errors in the calculations.
Could you do that without creating new columns?
Specifically, I have the following two columns: (min,value) , and I don't want to add any new column.
In principle, I would like the following formatting:
violation when value smaller than min-eps : show min in red background
hit when value in range [min-eps,min+eps] : show min in blue background
valid when min+eps smaller than value : show min in white background
where eps is a very small constant that I use to account for rounding errors in the calculations.
Could you do that without creating new columns?
Last edited: