Hello, As above - needs a hint in the topic. I guess it's something very simple - I know how to change colors if the cell is empty - but I don't know how to write this predetermined text :) Please help :) in the conditioning record :) Thank you in advance - and sorry for the banal...

I don't really understand - you want to enter text when the cell is empty, then it won't be empty anymore. There is no point in doing this. But you could do it in a different cell which is: (for example) If cell A1 is blank, enter text in B1, otherwise enter A1 1: in cell B1, the formula = IF (A1 = 0, text, A1) 2: In cell A1, the value is 0, blank or otherwise

You enter the defined text in quotation marks as the equality condition and you set the conditional formatting to the cell (or range) you want to color. See attachment. @mickpr This is not exactly what the topic is about.

There is something like conditional formatting where - it depends on the EXCEL version. In version 2003 - From the menu Format-> Conditional formatting

Hello, I found - it's conditioning - but how do I write it down?

Sorry for not a very understandable question! But the matter is solved anyway - great :) Many thanks - mickpr and Marcin230 !!

Excel - change the background color of cells if there is specific text in anothe

the_legion 26251 5

Treść została przetłumaczona

Zobacz oryginalną wersję tematu

Reply | New topic

#1 10732465 29 Mar 2012 13:53

the_legion the_legion

Level 9

» |

Post #1
10732465 29 Mar 2012 13:53

Hello,

As above - needs a hint in the topic. I guess it's something very simple - I know how to change colors if the cell is empty - but I don't know how to write this predetermined "text" :)

Please help in the conditioning record :)

Thank you in advance - and sorry for the banal question
ADVERTISEMENT
#2 10732531 29 Mar 2012 14:12

mickpr mickpr

Level 39

» | Helpful post? (+1)

Post #2
10732531 29 Mar 2012 14:12

There is something like conditional formatting where - it depends on the EXCEL version. In version 2003 - From the menu Format-> Conditional formatting
ADVERTISEMENT
#3 10732589 29 Mar 2012 14:29

the_legion the_legion

Level 9
» | Topic author Helpful post? (+1)

Post #3
10732589 29 Mar 2012 14:29

Hello,

I found - it's conditioning - but how do I write it down?

Attachments:

untitled.JPG Download (35.84 KB)
ADVERTISEMENT
Helpful post

#4 10733609 29 Mar 2012 18:49

mickpr mickpr

Level 39

» | Helpful post? (+1)

Helpful post
Post #4
10733609 29 Mar 2012 18:49

I don't really understand - you want to enter "text" when the cell is empty, then it won't be empty anymore. There is no point in doing this.

But you could do it in a different cell which is:
(for example) If cell A1 is blank, enter "text" in B1, otherwise enter A1

1: in cell B1, the formula
= IF (A1 = 0, "text", A1)

2: In cell A1, the value is 0, blank or otherwise
ADVERTISEMENT
Helpful post

#5 10733965 29 Mar 2012 20:07

Anonymous Anonymous

Anonymous
» |

Helpful post
Post #5
10733965 29 Mar 2012 20:07

You enter the defined "text" in quotation marks as the equality condition and you set the conditional formatting to the cell (or range) you want to color. See attachment.

@mickpr
This is not exactly what the topic is about.

Attachments:

kolory.xls Download (20.5 KB)
#6 10734608 29 Mar 2012 21:55

the_legion the_legion

Level 9

» | Topic author Helpful post? (+2)

Post #6
10734608 29 Mar 2012 21:55

Sorry for not a very understandable question!

But the matter is solved anyway - great :)

Many thanks - mickpr and Marcin230 !!
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 - change the background color of cells if there is specific text in anothe

Didn't find an answer? Ask Artificial Intelligence