Hello, I created a spreadsheet and I would like people using it to have only those fields that need to be completed highlighted. When they are empty, they will be highlighted in red! Please help!

Conditional formatting - rules for highlighting cells

Hello again, I have another question and I don't want to start a new topic. What to do to: When you enter the value n / a in the summary 0 into a cell, and for any other value, it will multiply it by another cell.

Excel: Conditional Formatting for Blank Cells

Reply | New topic

#1 13743919 26 Jun 2014 16:04

Myslaw Myslaw

Level 9

» |

Post #1
13743919 26 Jun 2014 16:04

Hello,
I created a spreadsheet and I would like people using it to have only those fields that need to be completed highlighted. When they are empty, they will be highlighted in red!
Please help!
ADVERTISEMENT
Helpful post

#2 13743943 26 Jun 2014 16:20

macsmial macsmial

Level 13

» | Positive voted Helpful post? (+18)

Helpful post
Post #2
13743943 26 Jun 2014 16:20

Conditional formatting - rules for highlighting cells
ADVERTISEMENT
#3 13743975 26 Jun 2014 16:24

Myslaw Myslaw

Level 9

» | Topic author Helpful post? (+2)

Post #3
13743975 26 Jun 2014 16:24

thank you ! you helped a lot.
#4 13746228 27 Jun 2014 11:12

Myslaw Myslaw

Level 9

» | Topic author Helpful post? (0)

Post #4
13746228 27 Jun 2014 11:12

Hello again, I have another question and I don't want to start a new topic.

What to do to:
When you enter the value "n / a" in the summary 0 into a cell, and for any other value, it will multiply it by another cell.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

Excel: Conditional Formatting for Blank Cells - Highlight in Red if Empty

Didn't find an answer? Ask Artificial Intelligence