I'm sure it's been asked before but can someone help me?


I'm trying to add a conditional format

if P2="x" then shade blue or if P2="y" then shade red


--
maccaz
------------------------------------------------------------------------
maccaz's Profile: http://www.excelforum.com/member.php...fo&userid=8849
View this thread: http://www.excelforum.com/showthread...hreadid=373830

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 :)


--
maccaz
------------------------------------------------------------------------
maccaz's Profile: http://www.excelforum.com/member.php...fo&userid=8849
View this thread: http://www.excelforum.com/showthread...hreadid=373830

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


--
spog00
------------------------------------------------------------------------
spog00's Profile: http://www.excelforum.com/member.php...o&userid=20197
View this thread: http://www.excelforum.com/showthread...hreadid=373830

Thanks Alastair

works a treat :)


--
maccaz
------------------------------------------------------------------------
maccaz's Profile: http://www.excelforum.com/member.php...fo&userid=8849
View this thread: http://www.excelforum.com/showthread...hreadid=373830

Try Format - Conditional Formatting

"maccaz" wrote:


I'm sure it's been asked before but can someone help me?


I'm trying to add a conditional format

if P2="x" then shade blue or if P2="y" then shade red


--
maccaz
------------------------------------------------------------------------
maccaz's Profile: http://www.excelforum.com/member.php...fo&userid=8849
View this thread: http://www.excelforum.com/showthread...hreadid=373830