Excel related

Solved/Closed
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Mar 21, 2012 at 08:47 AM
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018 - Mar 22, 2012 at 11:19 AM
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
Related:

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Mar 22, 2012 at 11:10 AM
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
DG83 Posts 38 Registration date Monday January 2, 2012 Status Member Last seen April 21, 2018
Mar 22, 2012 at 11:19 AM
Thank you very much!