Solved: Conditional Format help

[sooty8]

Hi All

Just need a little help to sort this out after a couple of hours trying - done a Conditional format on the attached sheet got it working ok on column A how do I change the colour format to the same as Column A on Column B also when I select either 1st - 2nd or 3rd.

Help much appreciated

Cheers

Sooty8

[Bob Phillips]

In B1:B20, use CF with a formula of

=AND(A1>="1st",A1<=3rd")

[sooty8]

Hi Xld

Placed this formula on another sheet =AND(E111>"1st",E111<="3rd")

1st does not work on entering however entering 2nd or 3rd works perfectly

What have I not entered correctly ??

Thanks for the help

Regards

Sooty8

[Teeroy]

It should work (and did for me, even down converting for excel 2003). I suspect there may be a leading (or middle) space in "1st" in E111. Trailing spaces are OK and middle spaces are sometimes acceptable but leading spaces cause a fail.

[sooty8]

Hi Guys

Thanks for the info all working OK after sorting out space errors and delayed reply due internet downtime.

Regards

Sooty8