A
A
aviism2019-06-19 18:31:23
Google Sheets
aviism, 2019-06-19 18:31:23

Google sheets. Problem with conditional cell formatting?

How can I make the cells color when my condition is met?
Cells in the range B5:C19 should be colored
Formula used:
= SUM (B26: B27) = 2
Tried through IF, through AND and through INDIRECT. Doesn't want to work.
Could it be that I am trying to get the value of a cell from another sheet?

spoiler
5d0a551186706210711137.png

spoiler
5d0a551874514906399233.png

spoiler
5d0a551df05ab159200058.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
Noir, 2019-06-19
@aviism

conditional formatting cannot link to another sheet
5d0a582b4a219412200439.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question