View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob McInnes Rob McInnes is offline
external usenet poster
 
Posts: 1
Default HOW DO I: Automatically colour a row according to cell content.

I'm trying to find a way to have a row's data range be automatically
coloured/patterned according to data I enter in a cell.

Examples: I have a column called "Action", and when I enter certain data
into the cell under this column I'd like the data row to automatically colour
(such as grey when I enter any of these: NIS, NQ, NI, WR
yellow when I enter any of these: LM, NA, CB, DO)