• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
condition formatting
#1
Hi 
Sir and Friends ek question h question ye h ki mere pass ek date h aur us date m ek condition formatting lagani h ki wo date 20 din ya 15 din pehle colour ho jaye 
sorry i can't upload file because this question post by phone so pls help me.

Thanks
  Reply
#2
Hello Angad,


Please find the attached solution. It will highlight all dates that falls in coming 20 days.


Attached Files
.xlsx   Conditional Formatting.xlsx (Size: 10.48 KB / Downloads: 9)
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Reply


Related Topics
Topic Author Replies Views Last Post
  Others If & And Condition Anil Kumar Pal 4 2,597 21-May-2019, 02:50 PM
Last Post: Anil Kumar Pal
  Conditional Formatting Indirect in conditional formatting Vijay Kumar 2 2,582 31-May-2018, 10:52 PM
Last Post: Vijay Kumar
  Pivot Table How to make pivot on below condition Anil Kumar Pal 1 1,829 16-May-2018, 01:00 PM
Last Post: Vivekananda Sinha
  Conditional Formatting Condition Formatting PRADEEP RASTOGI 3 3,030 20-Feb-2018, 10:12 PM
Last Post: sanj_edu
  Conditional Formatting Condition Formatting PRADEEP RASTOGI 1 2,213 11-Jan-2018, 08:54 PM
Last Post: sanj_edu
  Data Validation Drop Down with condition Dharmesh Kumar Srivastava 2 2,639 29-Dec-2017, 09:09 PM
Last Post: sanj_edu
  Conditional Formatting Count of duplicate value as single, on condition based Dharmesh Kumar Srivastava 1 2,493 18-Oct-2017, 04:04 PM
Last Post: Mohit Sharma
  Formula Condition based status update Dharmesh Kumar Srivastava 8 5,911 16-Oct-2017, 05:15 AM
Last Post: HARIOMSINGH
  Number Format Excel Number formatting issue Yogesh kumar 1 2,602 05-Oct-2017, 11:04 PM
Last Post: Mohit Sharma
  Conditional Formatting Query conditional Formatting Manish Kumar Gera 7 5,842 14-Jul-2017, 02:23 PM
Last Post: Amit Dhankar
  Conditional Formatting conditional formatting Vinod Dobhal 1 2,666 10-Jul-2017, 08:23 PM
Last Post: Lovedeep sharma
  Conditional Formatting condition format Yogesh kumar 1 2,594 10-Jul-2017, 08:02 PM
Last Post: Lovedeep sharma
  Formula Sum & If in double condition Gaurav Agarwal 2 3,199 06-Jul-2017, 06:28 PM
Last Post: Vivekananda Sinha
  Conditional Formatting conditional formatting Laxman 1 2,534 04-May-2017, 01:44 PM
Last Post: Vijay Kumar
  Conditional Formatting Conditional Formatting Vijay Kumar 1 3,210 03-May-2017, 09:32 PM
Last Post: Vivekananda Sinha

Forum Jump:


Users browsing this topic: 1 Guest(s)