Conditional Formatting

[excelisgood]

Hi,
Am not very good with excel,but am currently working on a spreadsheet. i have managed to do a conditional format to a cell (B2) which is when A2 is equal to P.
My formula is =$A$2=$O$2 and works fine where cell 'O2' has P in it...but i now need to add this rule to the whole B column as i have 426 rows and i don't want to do this rule individually for each 426 rows. i want B2 to be highlighted looking up if A2 has P.... and B3 to highlight if A3 is equal to P ... B4 highlight if A4 is equal to P and so on...

I tried selecting the whole column which which then my formula was =$A:$A=$O$2 but nothing happens?..


P is just the status of projects meaning its a priority.
Am using 2010 version

If anyone could points me towards the right direction, will greatly appreciate.

[TMS]

Try:

=$A2=$O$2


Regards, TMS

[excelisgood]

ok so i select the whole column B, condtional format, new rule and puts the formula as =$A2=$O2 this now highlight whole column where A cells are blank but now the the B cells where the corresponding A cell has a P in it or any other status in (L,M,H)..

[TMS]

Sorry; I edited the original formula. I hadn't realised, at first, that O2 is an absolute location.

I therefore changed it from =$A2=$O2 to =$A2=$O$2. The original compares A2 to O2, A3 to O3, A4 to O4, etc. The new version compares A2 to O2, A3 to O2, A4 to O2, etc.

Regards, TMS

[excelisgood]

It works!! thanks a lot.

[TMS]

You're welcome. Thanks for the rep.