Conditional formatting for non-empty cell
Solved
dzouve
Posted messages
32
Registration date
Status
Membre
Last intervention
-
dzouve Posted messages 32 Registration date Status Membre Last intervention -
dzouve Posted messages 32 Registration date Status Membre Last intervention -
Hello,
I would like to know how to apply conditional formatting in Excel 2007 for a non-empty cell
Here is my example
In cell A1, there is a name (always)
In cell A2, there is a name from time to time
I want the conditional formatting to set cell A1's background to red if cell A2 is not empty.
My question is what method to use and please confirm that I should apply the formatting directly linked to cell A1
Thank you in advance for your help
Joel
I would like to know how to apply conditional formatting in Excel 2007 for a non-empty cell
Here is my example
In cell A1, there is a name (always)
In cell A2, there is a name from time to time
I want the conditional formatting to set cell A1's background to red if cell A2 is not empty.
My question is what method to use and please confirm that I should apply the formatting directly linked to cell A1
Thank you in advance for your help
Joel
Configuration: Windows Vista Internet Explorer 7.0
Joel