A
A
Alina Shah2021-08-25 00:23:16
excel
Alina Shah, 2021-08-25 00:23:16

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

1 answer(s)
G
Grigory Boev, 2021-08-25
@Shah_Alina

  1. Conditional Formatting
  2. Own formula
  3. =СЧЁТЕСЛИ($C$1:$J$1;$K$1)>0
  4. And make the text the same as the background when the condition is triggered

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question