How to compare three or more columns with a benchmark?

K

K

kondrash0552018-05-03 20:00:25

excel

kondrash055, 2018-05-03 20:00:25

How to compare three or more columns with a benchmark?

Good evening.
There is a Google table of the form:
standard price1 price2 price3
100 110 90 80
150 160 140 170
How to line by line color a value that is less than the standard?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton Kiselyov, 2018-05-03
@zamboga

Google "conditional formatting"

Similar questions

M

Maximkalenin2015-11-13 13:13:28

Writing Excel macros, what skill do you need? 4Reply

A

Al Tinho2015-11-16 11:03:35

Doesn't print from Excel? 2Reply

A

Alexander2020-05-13 17:15:29

Question about selecting cells in Excel? 2Reply

B

Bartiwka2018-03-31 10:47:45

How to determine the operating range? 1Reply

M

mpetrunin2015-11-27 19:36:11

How can a set of points plot a graph and cut off the noise (outliers)? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question