Format a cell based on cells in the same row

[colinharwood]

Hi
Is there a way, to format cell C10 to be green if any of the cells in the range D10:S10 contain text,
I have been trying conditional formatting, but cannot find a way to make it work
Thanks
Colin

 

[etaf]

=counta(d10:s10)>0

counta - test to see if a cell is empty

or do you mean contains text and not a number
If TEXT then try using
=COUNTIF(D10:S10,"*")>0

Book3
	A	B	C	D	E	F	G	H
7
8		COUNTIF()	1
9
10		COUNTA()	2		1	a
11
12
Sheet2

Cell Formulas
Range	Formula
C8	C8	=COUNTIF(D10:S10,"*")
C10	C10	=COUNTA(D10:S10)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C10	Expression	=COUNTA(D10:S10)>0	text	NO

 

[colinharwood]

Hi Etaf
Thanks a lot, problem solved
Colin

 

[etaf]

you are welcome