Thread: fill cells with colour if content of another cell has CR
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Inserting an option button in Word Inserting an option button in Word is offline
external usenet poster
  
Posts: 13
Default fill cells with colour if content of another cell has CR
I would like to fill colour the range A6:AV6 with red if the content of cell
AP7 is CR
I need to do this then for about 75 to 80 rows below this so next row would
be looking for CR in cell AP8 etc. If I can do it without code, great. Any
help appreciated.
Reply With QuoteReply With Quote