Conditional Formatting based on text in 3 columns

[james787r]

Hi All,

I was wondering if anybody could help me with my conditional formatting query. I will try and elaborate as best I can.

I have a list of names in column A from range A3:A16
I have columns C-H with some cells containing the words "Not done"
I would like the names in column A to format if two or more columns from C-H contain the text "Not done"

I'm not sure how or what formula to use so appreciate any help that can be provided.

Many thanks

 

[Chris Mack]

This should work, applied to A3:A16.

=COUNTIF(C3:H3,"Not done")>=2

Hope this helps,

Chris.

 

[Special-K99]

Try (untested)

Select A1

Conditional Formatting
New Rule
Use a formula to determine...

=(COUNTIF(C1:H1,"Not done")>1)
format as required

Use Format painter to copy to other cells

 

[james787r]

This should work, applied to A3:A16.

=COUNTIF(C3:H3,"Not done")>=2

Hope this helps,

Chris.

Perfect...thank you for such a quick reply

 

[Chris Mack]

Np!