Excellent, thanks for that, modified it slightly and it works perfectly.
Added $ to the B1, eg. =COUNTIF($B1,"*Not Issued*")0


"L. Howard Kittle" wrote:

Select the cells you want to check for Not Issued. Say B1:B5

In Format Conditional formatting Formula Is =COUNTIF(B1,"*Not
Issued*")0 Format Patterns click on green OK out.

So now if you select B5 and note the conditional formatting in it, you will
see the formula refers to B5 in that cell.

Is not case sentive.

Here is the formula again if perhaps the 's got you confused in my
instructions.

=COUNTIF(B1,"*Not Issued*")0

HTH
Regards,
Howard

"Missile" wrote in message
...
After some help with Conditional Formatting.
As an example I have the following data in cells B1 & B2;
Cell B1 "Project 1 - Testing"
Cell B2 "Project 2 - Not Issued"
I want the cells containing the words "Not Issued" to be shaded (Green).
In
this example that would be "B2".
Also I would like the same shading applied to cells A2, C2 to H2.


Thanks


.