| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
