View Single Post
  #1   Report Post  
Ellie
 
Posts: n/a
Default Possibly conditional format

I have an Excel 2000 spreadsheet with Column G having random numbers from 1-20.

I am trying to find a way whereby:-
1) Numbers 1,3,4,8,10-12,14-19 highlight the cells in red, and
2) Numbers 2,5-7,9,13 and 20 are highlighted in orange

Is there a particular formula I may be able to use in conditional format, or
would another process be more suited to this task.

Many thanks.