Did you change those column A references to column G?
Ellie wrote:
Hi Aristotle
Thanks for your response. Unfortunately, it didn't work out.
Many thanks for your reply though.
Ellie
"aristotle" wrote:
Hi,
Select e.g. A1:A100
Go to Format-Conditional Format - Formula
The first condition formula should appear as follows:
=IF(OR(A1=1,A1=3,A1=4,AND(A1=10,A1<=12),AND(A1=1 4,A1<=19)))
choose the desired format...
The second condition formula should appear as follows:
=IF(OR(A1=2,AND(A1=5,A1<=7),A1=9,A1=13,A1=20))
choose the desired format...
I haven't tested this so hope it's right.
Regards,
A
"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
|