Previous Topic Next Topic

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

Answer 1 / 2
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
0
Answer 2 / 2
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!
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses