View original (French)

Excel and cells colored if text

Jimmy -  
 Chap -
Hello,

I would like to do something on Excel but I'm stuck on a part.
I want all my cells from B3 to L3 to turn green if I write "Yes" in cell "L3", otherwise nothing.
I have tried the IF formula, but it doesn't work for this kind of problem.
I tried conditional formatting, but unfortunately, it only colors the cell where "Yes" is written and not the rest as I would like.

I thank in advance anyone who will help with my problem,

Best regards,

Jimmy.

Configuration: Windows 7 / Firefox 10.0.1

6 réponses

Réponse 1 / 6
chossette9 Posted messages 6855 Registration date   Status Contributeur Last intervention   1 313
 
Hello,

in Excel 2007:
1°) Select the cells from B3 to L3
2°) Home -> Conditional Formatting -> New Rule
3°) Choose "Use a formula to determine which cells to format"
4°) Enter =$L$3 = "Yes"
5°) Choose the format to apply
6°) Ok, Ok

Best regards.
--
This guy was not very bright, as he was foolish.
6
nightsheart Posted messages 319 Registration date   Status Membre Last intervention   30
 
Is it not possible to do this on 2003? Just to know.
0
chossette9 Posted messages 6855 Registration date   Status Contributeur Last intervention   1 313
 
It is entirely possible to do it under 2003.
However, the procedure mentioned above only works for 2007 and 2010 since it refers to the Ribbon interface of the menu.
0
Chap
 
Great, thanks! It's exactly what I was looking for!
0