Conditional formatting formula help

[apearson]

Hi,
I have a column containing data as follows:- (DTASP3, DTWEND, DTNS1W) etc. I want to fill the cell with colour for certain one's, ie all the those cells which are DTWEND.

I have used this:- =COUNTIF(F:F,F1)>1 for a column with numeric data, but can't find a formula which I can use with conditional formatting for the above.

Can anyone help please!

Thanks, Alley

 

[energman58]

In the conditional formatting dialiog box for one of the cells (say A1) enter the formula:

=A1="DTWEND"

And adjsut the format as required

Just make sure that Excel doesnt put in any $ signs and just copy the formatting to the rest of teh column

 

[grizz]

conditional format / cell value is / equal to / DTWEND
and format your colour

 

[apearson]

Thanks for that, but I want it to pick up more than one set of data, and colour that cell too!

Alley

 

[energman58]

Do you want to something like your countif formula?

If so sumproduct will work

=SUMPRODUCT(--(A1:A10="WHATEVER"))>1

 

[grizz]

you'll have to be more specific

 

[apearson]

Thank you to everyone that contributed!

Cheers.