Excel related [Solved/Closed]

Report
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
-
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018
-
Hello,

could you please tell me how I get excel to automatically use a color in a cell that I write something into? The blank ones can remain colorless but I want a color in a cell that contains something.

THank you so much

2 replies

Posts
2657
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 22, 2020
440
Hi DG83,

Click on the spot to the left of the column letter A and above the row number 1 to select all cells (or Ctrl+A).
Goto conditional format:
First dropdown list: cell value is
Second dropdown list: not equal to
Third area: =""
Apply your format and confirm your actions.

Best regards,
Trowa
Posts
38
Registration date
Monday January 2, 2012
Status
Member
Last seen
April 21, 2018

Thank you very much!