| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More specific question about adding color code
I am trying to do the following without success
1A = company name 1B = renewal date ex 07/19/2007 1Z (hidden) Has current date which updates to current date each time excel is opened ex 06/20/2007 =IF(1Z-1B120 days) then change cell 1A to yellow Can someone help me with this. Thanks in advance -- Neall |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
More specific question about adding color code
in Conditional formatting:
FormulaIs: =AND(B1<"",($Z$1-B1)120) set color OK "Neall" wrote: I am trying to do the following without success 1A = company name 1B = renewal date ex 07/19/2007 1Z (hidden) Has current date which updates to current date each time excel is opened ex 06/20/2007 =IF(1Z-1B120 days) then change cell 1A to yellow Can someone help me with this. Thanks in advance -- Neall |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
More specific question about adding color code
i hope i can help by giving sample to answer briefly your specific question.
example: Pedro wants to know when the fruit will be ripe by having cell A1 to remain on green then turns yellow when the specified time difference has been reached. go to cell A1, click menu FormatConditional formattingcondition 1use "formula is, type (without quotes) either "=(z1-b1)120" or Maybe "=(today()-b1)120" then choose the formatfont/border/pattern to show the Yellow.... regards, driller -- ***** birds of the same feather flock together.. "Neall" wrote: I am trying to do the following without success 1A = company name 1B = renewal date ex 07/19/2007 1Z (hidden) Has current date which updates to current date each time excel is opened ex 06/20/2007 =IF(1Z-1B120 days) then change cell 1A to yellow Can someone help me with this. Thanks in advance -- Neall |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
More specific question about adding color code
or the same also in another form like FormulaIs: =(B1<"")*($Z$1-B1)120 -- ***** birds of the same feather flock together.. "Toppers" wrote: in Conditional formatting: FormulaIs: =AND(B1<"",($Z$1-B1)120) set color OK "Neall" wrote: I am trying to do the following without success 1A = company name 1B = renewal date ex 07/19/2007 1Z (hidden) Has current date which updates to current date each time excel is opened ex 06/20/2007 =IF(1Z-1B120 days) then change cell 1A to yellow Can someone help me with this. Thanks in advance -- Neall |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code for opening a workbook at a specific time!?! | Excel Discussion (Misc queries) | |||
| Use a code to populate a cell with a specific value | Excel Worksheet Functions | |||
| How to color automatically color code sums in cells | Charts and Charting in Excel | |||
| adding and subtracting using vb code | Excel Discussion (Misc queries) | |||
| how to color code a row of cells based on a specific cell value | New Users to Excel | |||
Linear Mode
