conditonal formatting question

[haydeeho]

i have a column that tells me how many weeks and days have elapsed since an order was placed in this format #w #d, i have used conditional formatting to make bold anything that is over 8w 0d........w/

....but when i use

to make anything over 10w 0d red.....i get all dates greater than 1w 0d.formatted.

any suggestions?
thanks in advance for any pointers!

[oldchippy]

Hello there,

It would be better if you could provide a small zipped sample of your worksheet; it would be easier to follow.

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.

[haydeeho]

for getting back to me. i figured out a workaround. have a great holiday!!!