Hi all,

I've got a worksheet that is showing five seperate workstreams. For the
column where the workstream is displayed I want the cell to turn a
specific color depending on which stream is chosen.

With three or less this would be simple - just use conditional
formatting, but Excel only allows up to three such criteria.

I've tried using an OR statement in "Formula is" to force at least have
some color in the fourth and fifth workstreams:

=OR("HS","BC 55")

But Excel's having none of it.

Not sure if there is a way to get around this. If anyone has a
suggestion it would be much appreciated.

TIA,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=554025