|Phil22, sorry to have to correct you,|
Using Conditional Formatting, It is possible, but you also need to use Defined Names.
It's tricky, but can be done.
Please explain, in detail, using Cell References with Column Letters and Row Numbers what it is your trying to do.
message edited by mmcconaghy