How to set up conditional formatting, cell number as text and cell filled?

Y

Y

yul_len62022-04-10 18:27:46

Google Sheets

yul_len6, 2022-04-10 18:27:46

How to set up conditional formatting, cell number as text and cell filled?

Hello!

How to set up conditional formatting in Excel so that cells are filled in in which the number is as text, is displayed as a number, but cannot be used in calculations, probably copied from somewhere, and at the same time the cell should not be empty? What formula to use?
Thank you.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander Ivanov, 2022-04-24
@yul_len6

Try using custom formula and formulaISTEXT()

Similar questions

V

valentin_gr2021-02-21 02:58:45

How to import a row from Google Spreadsheets into a Google Form so that when the form is opened, a different question pops up each time? 1Reply

P

PiShim2021-02-25 11:51:47

How to sort a range created by formulas? 1Reply

D

Dmitry Klimantovich2021-02-26 12:45:23

How to exclude empty columns in FLATTEN? 0Reply

E

Evgenia Satonina2019-08-08 16:57:41

How to assign a number to a cell with text in google spreadsheets? 1Reply

N

n_konovalov2021-03-11 17:52:05

How to fix import to Google Spreadsheets from the Moscow Exchange? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question