Color a cell when another is non-empty

Solved
Cé. -  
 MissCad -
Hello,

I am a beginner, but I would like to color a cell when another is "not empty" and therefore contains a date, more specifically:

In column B, I have names - text. In G, there are sometimes dates and sometimes nothing. I would like the text in column B to be colored green when there is a date entered in column G and to remain black when there is nothing in G.

I hope I am not too confusing in my explanations...

Thank you in advance for your response.

Cé.

Configuration: Windows 7 / Mozilla 11.0

1 réponse

via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Hello Cé

Select column B then Home - Conditional Formatting - New Rule - Use a formula to determine which cells to format...
enter the formula =$G1<>"" before choosing the desired format and validating

Best regards
Via

--
"Imagination is more important than knowledge." A. Einstein
13
Cé.
 
It's perfect!

Thank you very much for your quick response!

Have a good day,

Cé.
0
Guillaume
 
Infinite recognition from a total beginner in Excel :)
0
MissCad
 
Simple and precise. Thank you for sharing.
0