Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format to turn text red after 56 days from previous se
Hi All
I hope someone can help. I have created a basic spreadsheet for trailer servicing I want to be able to see the next service date text change to red (through conditional formating) should the service date have exceeded 56 days to the next service date. Thanking you in advance for any help Kind Regards Ash |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format to turn text red after 56 days from previous se
for example u have two dates as in A1 and A2
Jan-30-08 Sep-30-08 create another column somewhere (i.e column D), which is difference between dates (i.e, D2=A2-A1) selcet A2, go to conditional formatting, click on new rules. select "Use formulla to determine which cell to format" type the formulla =D256 select your format color etc, click OK, this should work. "Ash45" wrote: Hi All I hope someone can help. I have created a basic spreadsheet for trailer servicing I want to be able to see the next service date text change to red (through conditional formating) should the service date have exceeded 56 days to the next service date. Thanking you in advance for any help Kind Regards Ash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Format or function to turn a number into text. | Excel Discussion (Misc queries) | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Change the text format for weekend days (Sat, Sun) | Excel Worksheet Functions | |||
entering a # each row adds 1 to the previous cell. Turn off? | Excel Discussion (Misc queries) |