I have a cell that is =GEO (geo being another cell that has geo locations
pulled from a DB)

In this cel (j14) I need to add a criteria that says if any geography shows
up that is not = to O7:O12 (list of geographys) then turn Red if cell J14
meets the criteria of O7:O12 then turn color XXXX

Any help would be greatly appreciated.

Thanks

--
Neall

You need conditional Formatting, see

'Excel Conditional Formatting'
(http://www.excel-it.com/excel_condit...formatting.htm)


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=101888