Rajendra_kodavaty
New Member
- Joined
- Oct 12, 2015
- Messages
- 23
Hey Team,
Thanks for your support along the way.
I Have a column CLR timeline that has dates as below, which are actually a result of the formula of a different column
<colgroup><col></colgroup><tbody>
</tbody>
I wanted to apply conditional formatting to this particular column, where if the
I am not able to find this option to apply today's date in Conditional formatting. Any suggestions are appreciated
Thanks
Thanks for your support along the way.
I Have a column CLR timeline that has dates as below, which are actually a result of the formula of a different column
CLR Time line |
16-Nov-17 |
17-Dec-17 |
16-Nov-17 |
16-Nov-17 |
16-Sep-17 |
17-Jan-18 |
14-Feb-18 |
17-Oct-17 |
17-Oct-17 |
17-Oct-17 |
16-Nov-17 |
17-Oct-17 |
16-Nov-17 |
16-Nov-17 |
17-Oct-17 |
16-Nov-17 |
14-Feb-18 |
16-Nov-17 |
17-Jan-18 |
24-Nov-17 |
25-Jan-18 |
22-Feb-18 |
<colgroup><col></colgroup><tbody>
</tbody>
I wanted to apply conditional formatting to this particular column, where if the
- Difference between that date and today's date is >= 30 then Cell will be green
- Number of days between the timeline and today's date is >= 20& <30 then cells should turn Yellow
- The difference in number of days is <20 the Cells should turn Red.
I am not able to find this option to apply today's date in Conditional formatting. Any suggestions are appreciated
Thanks