How to use conditional formatting for dates [on hold]
I want to use Conditional formatting for filling cells that contain a date that's happening in 6 months or less but every time I use '=$E2-TODAY()<=180' it fills cells that doesn't follow the condition
N.B: dates are all under column E starting at E2 to E84
and how can I apply more than one rule to the same column like under 6 months and over 5 months fills a color and under 5 months fills another color
thanks in advance
windows windows-7 window format microsoft-office
asked Jan 22 at 19:21
Ahmed Fadl Jr.Ahmed Fadl Jr.
12
New contributor
Ahmed Fadl Jr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
put on hold as off-topic by Terrance, Ravexina, user535733, wjandrea, Jacob Vlijm Jan 22 at 20:23
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This is not about Ubuntu. Questions about other Linux distributions can be asked on Unix & Linux, those about Windows on Super User, those about Apple products on Ask Different and generic programming questions on Stack Overflow." – Terrance, Ravexina, user535733, wjandrea, Jacob Vlijm
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I want to use Conditional formatting for filling cells that contain a date that's happening in 6 months or less but every time I use '=$E2-TODAY()<=180' it fills cells that doesn't follow the condition
N.B: dates are all under column E starting at E2 to E84
and how can I apply more than one rule to the same column like under 6 months and over 5 months fills a color and under 5 months fills another color
thanks in advance
windows windows-7 window format microsoft-office
asked Jan 22 at 19:21
Ahmed Fadl Jr.Ahmed Fadl Jr.
12
New contributor
Ahmed Fadl Jr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
put on hold as off-topic by Terrance, Ravexina, user535733, wjandrea, Jacob Vlijm Jan 22 at 20:23
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This is not about Ubuntu. Questions about other Linux distributions can be asked on Unix & Linux, those about Windows on Super User, those about Apple products on Ask Different and generic programming questions on Stack Overflow." – Terrance, Ravexina, user535733, wjandrea, Jacob Vlijm
If this question can be reworded to fit the rules in the help center, please edit the question.
For questions about using software on Windows, ask on Super User
– wjandrea
Jan 22 at 19:56
add a comment |
I want to use Conditional formatting for filling cells that contain a date that's happening in 6 months or less but every time I use '=$E2-TODAY()<=180' it fills cells that doesn't follow the condition
N.B: dates are all under column E starting at E2 to E84
and how can I apply more than one rule to the same column like under 6 months and over 5 months fills a color and under 5 months fills another color
thanks in advance
windows windows-7 window format microsoft-office
asked Jan 22 at 19:21
Ahmed Fadl Jr.Ahmed Fadl Jr.
12
New contributor
Ahmed Fadl Jr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I want to use Conditional formatting for filling cells that contain a date that's happening in 6 months or less but every time I use '=$E2-TODAY()<=180' it fills cells that doesn't follow the condition
N.B: dates are all under column E starting at E2 to E84
and how can I apply more than one rule to the same column like under 6 months and over 5 months fills a color and under 5 months fills another color
thanks in advance
windows windows-7 window format microsoft-office
windows windows-7 window format microsoft-office
asked Jan 22 at 19:21
Ahmed Fadl Jr.Ahmed Fadl Jr.
12
New contributor
Ahmed Fadl Jr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Jan 22 at 19:21
Ahmed Fadl Jr.Ahmed Fadl Jr.
12
New contributor
Ahmed Fadl Jr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Jan 22 at 19:21
Ahmed Fadl Jr.Ahmed Fadl Jr.
12
New contributor
Ahmed Fadl Jr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Jan 22 at 19:21
Ahmed Fadl Jr.Ahmed Fadl Jr.
12
asked Jan 22 at 19:21
Ahmed Fadl Jr.Ahmed Fadl Jr.
12
12
New contributor
Ahmed Fadl Jr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Ahmed Fadl Jr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Ahmed Fadl Jr. is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
put on hold as off-topic by Terrance, Ravexina, user535733, wjandrea, Jacob Vlijm Jan 22 at 20:23
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This is not about Ubuntu. Questions about other Linux distributions can be asked on Unix & Linux, those about Windows on Super User, those about Apple products on Ask Different and generic programming questions on Stack Overflow." – Terrance, Ravexina, user535733, wjandrea, Jacob Vlijm
If this question can be reworded to fit the rules in the help center, please edit the question.
put on hold as off-topic by Terrance, Ravexina, user535733, wjandrea, Jacob Vlijm Jan 22 at 20:23
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "This is not about Ubuntu. Questions about other Linux distributions can be asked on Unix & Linux, those about Windows on Super User, those about Apple products on Ask Different and generic programming questions on Stack Overflow." – Terrance, Ravexina, user535733, wjandrea, Jacob Vlijm
If this question can be reworded to fit the rules in the help center, please edit the question.
For questions about using software on Windows, ask on Super User
– wjandrea
Jan 22 at 19:56
add a comment |
For questions about using software on Windows, ask on Super User
– wjandrea
Jan 22 at 19:56
For questions about using software on Windows, ask on Super User
– wjandrea
Jan 22 at 19:56
For questions about using software on Windows, ask on Super User
– wjandrea
Jan 22 at 19:56
add a comment |
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
For questions about using software on Windows, ask on Super User
– wjandrea
Jan 22 at 19:56