How to paint an area with color when data appears in another cell?

D

D

Dmitry Egregor2021-08-19 09:22:38

excel

Dmitry Egregor, 2021-08-19 09:22:38

How to paint an area with color when data appears in another cell?

How to make it so that when any data appears in a cell, another cell, or several cells, are colored?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2021-08-19
@EGREGOR_Dmitriy

Select the range in which to change the color
Conditional Formatting
Own formula

=$A$1<>""
So when something appears in A1, the color will change in the original range

Similar questions

S

SteepZero2018-03-06 12:28:22

Is it possible to add text formatting to a CSV file for Excel? 1Reply

O

Oleg Seledets2018-03-09 13:31:10

Is it possible to organize communication between QT, mySQL and Excel? 5Reply

@

@phgrey2011-12-03 21:02:30

Excel in the browser 3Reply

Z

Zickname2020-05-08 16:49:37

Calculate the sum in cells if there are several values in each cell? 1Reply

A

APetrov2112015-11-12 09:22:58

What are dbf editors with filtering and viewing individual records? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question