View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default highlighting rows according to a input value?

eg. value 1 and 2 in a cell should make an entire row red

eg. value 3 to 6 in a cell should make an entire row blue

Ideally I want a formula when if I put 1 or 2 into a cell it highlights
the row as red

maybe I if I input a 3, 4, 5, 6 it highlights red

Any thoughts? Thanks in Advance.