Conditional Formatting- extending to whole row

Using the oldest version of Excel (200) I have to insure all members of our squad can utilize this function. Trying to format a whole row based on one cell in that row that reports number of days till the next physical. My formatting works correctly for the initial cell, but does not extend correctly to the rest of the row. I am using the "Cell value is" option. I used:

Cell value is between 1 and 365 - color green
Cell value is between 0 and -30 - Color Yellow
Cell value is between -31 and -365 Color Red.

All cells with no value in it are yellow, even if the original formatted cell is another color and the cells that have other data in them such as the physical date, have no color in them regardless. read and tried several approaches from other threads with no good results. considering the results from those threads, I am curious if it has to do with it being an older version.

Thanks in advance.

For discussion assume cell A1 holds the value

Beginning with the first cell in the range to apply CF, select all cells in the applicable range.
Apply CF using the Formula Option and use these formula

CF #1: AND($A1>=1, $A1<=365)
CF #2: AND($A1>=-30,$A1<=0
CF #3: AND($A1>=-365,$a1<=-31)

Excel will apply the CF formual to all cells across the columns, adjusting the row reference so that all rows have the CF applied. Note the use the absolute column reference in the formula.

Originally Posted by rhlongo

That was perfect. Thank you for your help, been out of the loop and I am just reworking my skills! Thanks again!

Glad to be of help.
Please mark your thread as solved by going to the top of YOUR first post. Click on Thread Tools, then Go Advanced and choose the [SOLVED] prefix.

See my signature for details on how to leave feedback to those who help answer your question.


EDIT: never mind about marking the post as solved. I see you've already done so. Thanks.