One way is to use Format|conditional formatting.
With column G selected and G1 the activecell, use Format|conditional formatting.
Formula is:
=ISNUMBER(SEARCH("."&G1&".",".1.3.4.8.10.11.12.14. 15.16.17.18.19."))
Give it a pattern of red under the format button.
(similarly for the orange values)
====
But I think I would create a new worksheet.
put those values in column A
1
3
4
8
10
11
12
....
Give that column a nice range name (insert|name|define MyRedCol)
And use a formula like:
=countif(myredcol,g1)0
And same kind of thing for myOrangeCol
Then I could just change those values in Sheet2 whenever I wanted to.
Ellie wrote:
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.
--
Dave Peterson
|