| Home |
| Search |
| Today's Posts |
|
#31
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incorporating Cell color fill in an "if" logical function?
FormatCFCondition1Formula is:
=$B$2-NOW()=30 Add Condition2 and 3 But you have a couple of conflicts with the <= and = Who do you want to win if the value is 30 Gord Dibben MS Excel MVP On Sun, 30 Aug 2009 20:52:01 -0700, Josh wrote: I am trying to shade the row if a particular cell in the row has a date value in one of three categories. What I have done is not working. Statements are below. ="If(($B$2-NOW)=30)" ="if(($B$2-NOW)<0)" ="If(($B$2-NOW)<=30)" It is not coloring a single cell.Any ideas of better logic to use? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
Threaded Mode
