View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ferdy Ferdy is offline
external usenet poster
 
Posts: 7
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