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

K

KTG2021-12-06 23:01:46

How to check if a cell is empty before calculating a cell? 2Reply

A

Alexey Mikhailov2020-08-24 16:27:50

How to display all dates of a month? 1Reply

M

mUchenik2020-08-27 09:53:28

How to link text + date? 2Reply

H

Hawk20242016-05-13 22:25:11

Why might the export of records from the database to Excel not work? 1Reply

K

kamwork2016-05-14 12:21:08

How to replace spaces inside a cell in Google Sheets with another character? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question