| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF looking at more than 1 cell
With this CF in column "D", "Cell Value is less than =NOW()", the cell colour
becomes red if the date in "D" is less than today's date. Column E may have text in it. So using CF, "D" to go red if date is less than NOW() but if text in "E", then remove red, i.e no formatting at all Any ideas? -- Traa Dy Liooar Jock |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CF looking at more than 1 cell
Formula Is, rather than Cell Value Is
=AND(D1<TODAY(),NOT(ISTEXT(E1))) If you want to use NOW() rather than today's date, you can change TODAY() in the formula to NOW() -- David Biddulph "Jock" wrote in message ... With this CF in column "D", "Cell Value is less than =NOW()", the cell colour becomes red if the date in "D" is less than today's date. Column E may have text in it. So using CF, "D" to go red if date is less than NOW() but if text in "E", then remove red, i.e no formatting at all Any ideas? -- Traa Dy Liooar Jock |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CF looking at more than 1 cell
Nice one, thanks David.
The issue I now have is that the formula I have in "D" [=IF(C6="Y","",A6+3)] treats A6 (which is empty) as 31/12/1900 with the result that all cells in "D" (more or less) are red! How do I get Excel to treat an empty cell as just that? -- Traa Dy Liooar Jock "David Biddulph" wrote: Formula Is, rather than Cell Value Is =AND(D1<TODAY(),NOT(ISTEXT(E1))) If you want to use NOW() rather than today's date, you can change TODAY() in the formula to NOW() -- David Biddulph "Jock" wrote in message ... With this CF in column "D", "Cell Value is less than =NOW()", the cell colour becomes red if the date in "D" is less than today's date. Column E may have text in it. So using CF, "D" to go red if date is less than NOW() but if text in "E", then remove red, i.e no formatting at all Any ideas? -- Traa Dy Liooar Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
