Excel related

Solved/Closed
DG83 Posts 38 Registration date Monday 2 January 2012 Status Member Last seen 21 April 2018 - 21 Mar 2012 à 08:47
DG83 Posts 38 Registration date Monday 2 January 2012 Status Member Last seen 21 April 2018 - 22 Mar 2012 à 11:19
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
22 Mar 2012 à 11:10
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 2 January 2012 Status Member Last seen 21 April 2018
22 Mar 2012 à 11:19
Thank you very much!