hi
and you are right. i didn't read close enough or read too quickly or
something.
thanks for the correction.

regards
FSt1

"L. Howard Kittle" wrote:

Hi FSt1,

Just to note, the OP says the cells will contain something like "Project 1 -
Not Issued". So =$B2="Not Issued" will not work if other characters are in
the cell.

=COUNTIF(B1,"*Not Issued*")0 looks for the occurrence of Not Issued among
all the characters in the cell.

Regards,
Howard

"FSt1" wrote in message
...
hi
while holding the Ctrl key down...with the mouse...select A2,C2 and H2.
on the menu barformatconditional format
Formula is.......=$B2="Not Issued"......pick your shade of green.
ok out.
the key is the dollar sign($). this points all selected cells in the row
at
column B but not the row so that you can copy A2:H2 and copy down as far
as
needed.

regards
FSt1

"Missile" wrote:

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


.