• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Highlight Entire Row using Conditional Formatting and Datedif formula

B

Bipin619

Member
Dear Experts,

I want to highlight the entire row instead of single cell using conditional formatting and datedif formula. Kindly help on it.

Thanks & Regards
Bipin
 

Attachments

  • Highlight entire row based on Cond Formt.xlsx
    441.4 KB · Views: 6
Hi, your formula is correct but your approach is probably wrong. Start by selecting cell A12 then make the rule in the CF, make sure you have the correct relative referencing, and apply on A12 only. Confirm, then change the apply on to the full range.
 

Attachments

  • Copy of Highlight entire row based on Cond Formt-1.xlsx
    441.9 KB · Views: 8
You must log in or register to reply here.
Back
Top