change the backcolor based on excel value

Hi guys

I want to write a formula/macro so that when the excel cell value reached to 365 then change the backcolor to red.

I hope anyone can help me out.

Thanks

you can use conditional formatting..

Actually the thing is we have to compare two dates and when the count reaches to 365 then change the backcolor to red.

I know we can do it using vba programming by creating form but we have to make it working without userform so may be writing macro will do.

Any help would be much appreciated.

Thanks

could you post a workbook and explain what exactly you need on the workbook.. i don't think i understand, what dates do you want to compare, what cell should be colored red?