Condional formatting

Sorry Manesh

I should have aded that it is cell A2 that I'm formatting.

So cell A2 should shade blue if P2=x or shade reds if P2=y

not very good at explaining myself sorry

In which case in conditional formatting use the drop down to seelct formula is and then p2=x and then select the blue format

then do the same for option 2, with formula is =p2=y and then format red.

Alastair

Thanks Alastair

works a treat