R
R
rar42019-01-03 18:03:08
Google Sheets
rar4, 2019-01-03 18:03:08

Conditional formatting of cells in a range, based on the fact that each individual cell has a value in another range. How to implement with one formula?

Each individual cell can be checked through the custom formula, where you specify =Vlookup() and look for this cell there.
But how to check the entire range at once - I haven’t figured it out yet.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Bcoon, 2019-01-03
@rar4

If I understand the question correctly, then the formula in UV will be something like this:
In general, it is better to attach a small example to such questions. Sketch data and manually touch up "as it should be". Then there will be more help

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question