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

D

Dmitry2018-09-05 10:58:22

How to put down the price when choosing a product in Excel? 1Reply

D

Denis Solovyov2016-04-12 10:11:49

How to make automatic unloading from 1C to Excel? 5Reply

F

FullWipe2014-02-04 20:01:16

How to write formulas in Excel? 1Reply

I

id_baton4eg2016-04-18 05:16:23

Excel how to add 5 days to a date with a formula? 1Reply

K

kuznetsovin2014-02-12 16:20:25

How to implement calling R or Python functions from Excel? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question