=IF(OR($H6=$D$4,$H6=$F$5),1,0)
ellebelle Wrote:
I have more than 3 conditions in my conditional formatting, however I
can get
it down to just three if I use OR function, however it never seems to
work.
I want an array of cells (H6:K10).
If a cell in an array equals a value in cell D4 or equals the value in
F5
then it should be orange.
I have three conditions like this.
can I do it?
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=390636