View original (French)

[EXCEL] Cell Color Based on Neighboring Value

Solved
anabreizh Posted messages 5 Status Membre -  
 tictachelp -
Hello,

I would like to find a formula that allows me to color a cell red based on the value of the adjacent cell.

Explanations:
In column A, I enter a text of my choice (text1, text2, or text3).
In column B, I want the cells to appear red if text2 or text3 appear in column A. If it is text1, the cell in column B remains white.

I have looked in conditional formatting, but I couldn't find anything.

Thank you very much for your help.

A.

NB: I am using Excel 2007

4 réponses

Réponse 1 / 4
g Posted messages 1285 Status Membre 577
 
Hello,

In conditional formatting, you use:

The formula is =OR(A1="text2",A1="text3")
which you apply to column B.

Have a good day.
3