Hi,
I am looking for a conditional formatting option where I can type a few formats for the following:
If I have a table say 40 rows by 30 columns and random numbers within ranging from 1-20, I would like to set a Conditional format that say highlights specific numbers eg:-
Any numbers in the range that have 1,7,8,11,13 highlight cell as green
Any numbers in the range that have 2,4,6,8,10 highlight cell as red
Any numbers in the range that have 3,4,5,14,15,16,17,20 highlight cell as blue
I am sure there is any easy way, but any help much appreciated.
Garry
Bookmarks