Thanks for feeding back, Richard - glad to be of help.

Pete

Richard wrote:
That hit the nail on the head! Thanks! Works great!!!!

"Pete_UK" wrote:

Richard,

you could try this variation in your CF formula:

=OR(LEFT($F$1,1)="5",$O$1=5000)

Hope this helps.

Pete


Richard wrote:
=OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in
cell F1 is being read as text (I think) and I need it to read as numerac.
Example: The cells that I need are selected and conditional formatted to
change to red if these criteria are met. If a 5 is in cell F1 or 5000 in cell
O1, The O1 cell works fine because it is a mumeric value but cell F1 has
=DATEDIF(A40,TODAY(),"M")&" months " which renders it not working. Any
suggestion as to reading F1 as a numeric value without changing this formula
in cell F1. Thanks in Advance