More conditional formating help

[Justin Greenwood]

Ok so I need to colour a cell if the range contains 1 or less of said text:

Kind of like this
=IF(COUNTIF($C$6:$C$15,"D")"=<1") True will turn cell C4 red.

 

[PCosta87]

Ok so I need to colour a cell if the range contains 1 or less of said text:

Kind of like this
=IF(COUNTIF($C$6:$C$15,"D")"=<1") True will turn cell C4 red.

Hi Justin

Please see attached

 

[Justin Greenwood]

Thanks PCosta thats worked just great

 

[PCosta87]

Thanks PCosta thats worked just great

You are welcome