View Single Post
  #1  
Old May 15th, 2010, 09:31 AM posted to microsoft.public.excel.worksheet.functions
ferdy
external usenet poster
 
Posts: 13
Default 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