Hi.
Use the formulas :
=LEFT(A1,3)="YES"
and
=LEFT(A1,2)="NO"
admitting A1 is the cell to format, and use formula instead of cell
value for the conditinal formatting.
HTH
Daniel
Hi All,

I have created a data validation table with conditional formatting, so that
when I select an item, the fill colour of of the cell also changes e.g. when
selecting "YES" from the drop-down menu, it enters the word "YES" and the
fill of the cell changes to green. The same with selecting "NO", it enters
the word "NO" and changes the cell fill colour to red.

I am using Excel 2003 which only allows me to have three (3) conditional
formats per cell.

I want to select any one of a number of items from the data validation list
to allow the one colour e.g.

"YES"
"YES - BUT"
"NO"
"NO - BUT"

I want to conditional format the cell that by selecting either "YES" or "YES
- BUT" it changes the cell fill colour to green and if selecting "NO" or "NO
- BUT" it changes the cell fill colour to red.

The problem is, four choices and only three cell conditions.

Does anyone know the formula to be able to select either item to produce the
cell fill colour i.e. ="YES" or "YES - BUT" produces a green cell fill
colour.

Many Thanks.
-
ray963