Answer the question
In order to leave comments, you need to log in
How to do conditional formatting by color?
https://docs.google.com/spreadsheets/d/1vqKnsN_8qQ...
In cell K1 , due to one formatting, the value turned gray - OK.
And now you need to make this value not bold, because. initially it is bold (well, the table looks more visually).
OR as another option to make it invisible at all, tk. it is repetitive and not informative.
OR: The value in cell K1 is displayed by the formula, you can write something else into it so that it is not initially displayed visible if there are the same values in the range C1:J1 .
I'm fantasizing now, but maybe there really is such a miracle formula or formatting?
Answer the question
In order to leave comments, you need to log in
=СЧЁТЕСЛИ($C$1:$J$1;$K$1)>0
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question