| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Difference between dates
If A1 is a date and B1 is a date. B1 is always scheduled to be 7 days after A1 but can be +/- 2 days. I need to hilight B1 when it is out of the +/- 2 day window with out hilighting empty cells. Thanks Gohan51D -- Gohan51D ------------------------------------------------------------------------ Gohan51D's Profile: http://www.excelforum.com/member.php...o&userid=32274 View this thread: http://www.excelforum.com/showthread...hreadid=521938 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting - Difference between dates
Hi!
If I understand.... Select cell B1 Goto FormatConditional Formatting Formula is: =AND(B1<"",B1=A1+4,B1<=A1+8) Click the Format button Select the desired style(s) OK out Biff "Gohan51D" wrote in message ... If A1 is a date and B1 is a date. B1 is always scheduled to be 7 days after A1 but can be +/- 2 days. I need to hilight B1 when it is out of the +/- 2 day window with out hilighting empty cells. Thanks Gohan51D -- Gohan51D ------------------------------------------------------------------------ Gohan51D's Profile: http://www.excelforum.com/member.php...o&userid=32274 View this thread: http://www.excelforum.com/showthread...hreadid=521938 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting - Difference between dates
Biff wrote:
Hi! If I understand.... Select cell B1 Goto FormatConditional Formatting Formula is: =AND(B1<"",B1=A1+4,B1<=A1+8) Click the Format button Select the desired style(s) OK out Biff That highlights cells that are IN the window. try =AND(NOT(ISBLANK(B1)),OR(B1-A1<5,B1-A19)) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting - Difference between dates
If I understand....
That highlights cells that are IN the window. That must mean that I didn't understand! Biff "Paul Lautman" wrote in message ... Biff wrote: Hi! If I understand.... Select cell B1 Goto FormatConditional Formatting Formula is: =AND(B1<"",B1=A1+4,B1<=A1+8) Click the Format button Select the desired style(s) OK out Biff That highlights cells that are IN the window. try =AND(NOT(ISBLANK(B1)),OR(B1-A1<5,B1-A19)) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting - Difference between dates
True, I didn't think of it that way!
Biff wrote: If I understand.... That highlights cells that are IN the window. That must mean that I didn't understand! Biff "Paul Lautman" wrote in message ... Biff wrote: Hi! If I understand.... Select cell B1 Goto FormatConditional Formatting Formula is: =AND(B1<"",B1=A1+4,B1<=A1+8) Click the Format button Select the desired style(s) OK out Biff That highlights cells that are IN the window. try =AND(NOT(ISBLANK(B1)),OR(B1-A1<5,B1-A19)) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting - Difference between dates
Actually changing your formula to: =NOT(AND(B1="",B1=A1+4,B1<=A1+8))
should work Biff wrote: Hi! If I understand.... Select cell B1 Goto FormatConditional Formatting Formula is: =AND(B1<"",B1=A1+4,B1<=A1+8) Click the Format button Select the desired style(s) OK out Biff "Gohan51D" wrote in message ... If A1 is a date and B1 is a date. B1 is always scheduled to be 7 days after A1 but can be +/- 2 days. I need to hilight B1 when it is out of the +/- 2 day window with out hilighting empty cells. Thanks Gohan51D -- Gohan51D ------------------------------------------------------------------------ Gohan51D's Profile: http://www.excelforum.com/member.php...o&userid=32274 View this thread: http://www.excelforum.com/showthread...hreadid=521938 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
| Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
Hybrid Mode
