Conditional Formatting

**jj33002** · 03-13-2007, 12:16 AM

I am having a problem with the conditional formatting. In lets say column A I have a1=1 days, a2=5 days, a3=16 days, etc. no knowing how many days in each cell, what I tried to do is set everything from 5 days and less to show up in bold but when I do anything that has a 1-5 even to begin with, lets say the 16 or even a number in the 20's 30's 40's or even 50's all show up in bold also. What I am putting in is Cell Value less than or equal to ="5 days"
Any ideas

**Carim** · 03-13-2007, 02:19 AM

Hi,

Use following formula ...

=VALUE(LEFT(A1,2))<=5

**jj33002** · 03-13-2007, 10:49 PM

I don't really understand what your formula is doing. I have a formula in the cell that gives me the number of days, it takes the date that has been entered into one cell and subtracts it from todays date and gives you the number of days until that day. That is why I was using the conditional formatting. I am not real sure what you want me to do with the formula you gave me.

A1=3-20-07 B1=A1-Today()
A2=3-25-07 B2=A2-Today().........I have other stuff after this that makes the value in column B give you # of days until the date in A1.