Excel Formula to colourfill cells when condition met
 

I daily populate a sheet sent to me with answers (time & dates) of 1,2 or 3
star items, the 3 star items I manually fill with a certain colour. Is there
any way of filling a row that contains a cell with 3 stars automatically with
a designated colour. In this example colour filling the whole row because one
of the cells contains ***


15-May bx3008 aaaaaaaaaaaa *** bbbbbbbbbbbbbbbb ccccccc

Excel Formula to colourfill cells when condition met
 

Select all the data - I will assume each row foes fro A to G and that the
data starts on row 1
In the conditional formatting dialog use this formula
=COUNTIF($A1$:G1,"*~*~*~")
The ~ are needed to tell Excel not to treat * as a wildcard
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Ferdy" wrote in message
...
I daily populate a sheet sent to me with answers (time & dates) of 1,2 or
3
star items, the 3 star items I manually fill with a certain colour. Is
there
any way of filling a row that contains a cell with 3 stars automatically
with
a designated colour. In this example colour filling the whole row because
one
of the cells contains ***


15-May bx3008 aaaaaaaaaaaa *** bbbbbbbbbbbbbbbb ccccccc

Excel Formula to colourfill cells when condition met
 

I think Bernard meant:

=COUNTIF($A1$:G1,"~*~*~*")

(slightly different order. ~* will represent that asterisk character.)

On 05/15/2010 08:05, Bernard Liengme wrote:
Select all the data - I will assume each row foes fro A to G and that
the data starts on row 1
In the conditional formatting dialog use this formula
=COUNTIF($A1$:G1,"*~*~*~")
The ~ are needed to tell Excel not to treat * as a wildcard
best wishes