Prev: Search for cell value
Next: Sort by Colour
From: Ferdy on 15 May 2010 04:31
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


From: Bernard Liengme on 15 May 2010 09:05
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" <Ferdy(a)discussions.microsoft.com> wrote in message
news:BC00CE38-DB02-4AB1-99AC-D4545CF535D9(a)microsoft.com...
> 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
>
>
From: Dave Peterson on 15 May 2010 09:11
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
 | 
Pages: 1
Prev: Search for cell value
Next: Sort by Colour