Turn Cell Colour
 

Select cell and then format - conditional formatting

if cells value
is = to
="YES"
and then set pattern to green

Your done

"Bar chart shows Zero''s" wrote:

Can someone help please, If cell n17 has the text "YES" placed in it can I
get the cell to automatically change green, and if I can ,can you tell me how
please.

Thanks

Kev