Nope you understood,
Its worked perfect, thanks for your help,
Steve.

"John Bundy" wrote:

If you are saying one more column (total of 3) with a y,n just select column
d and insert column and repeat the process you did with the first two.
Then this would be your formula
=IF(D11="y",IF(E11="y",IF(F11="y","Complete","Not Complete"),"Not Complete"))

if i misunderstand let me know
John

"k1ngy" wrote:

Spot on that worked perfect,
one other question though, how do i add to this so i have d11 and e11 then
add a column so f11 has a y,n and g11 becomes the complete,not complete,
Thanks,

"John Bundy" wrote:

In the two columns you want y or n highlight the area you want these
selections to be in, then go to Data-Validation under allow select list and
in the box type Y, N. This makes a dropdown in those cells in which you
choose one or the other (you can still type if you rather).

If D11 and E11 have you Y and N the F11 formula would be:
=IF(D11="y", IF(E11="y","Complete","Not Complete"),"Not Complete")

select all cells with this formula
Next go to Format-Conditional Format and in the second box choose equals
and in the box that appears to the right type Not Complete, then on the third
tab select a color such as red. That should do you!
John


"k1ngy" wrote:

Hi,
I have a chart and in it at the end i want a cell to say complete or not
complete depending on answers in previous cells, for example
Processes to do date due checked wi complete complete?
returns 15-Dec Y N complete
Picking 15-Dec Y Y not complete
So word returns is A2 15Dec is B2 so on to complete or non complete in E2 an
so on down so all i enter is Y or N in checked and wi complete boxes and
words complete or not complete enter themselves. Also if there is something
funky with the colour of the box or text even better,
Please help ta,
Steve.