Get instant live Excel expert help to learn how to highlight a cell in Excel

I have 2 cells B2 & H2, both with dates in them, I want to highlight the date H2 in the second cell if it falls within 90 days of the first cell B2

I need a formula to highlight dates 3 days before the TODAYS date

I need the due date of TODAY to highlight red. I need the due date in the cell to highlight yellow 7 days before the date shown in the cell. I need the due date in the cell to highlight red if the actual date is past the date shown.

i need a formula to highlight the cells, i will enter the total value excel should highlight the cells which sum equals to that value

I need a section highlighted if the date falls on the next to last Monday. Highlight K1:m5, as well as A37:m44 if K1 falls on the next to last Monday of a month

I need a formula that if the sum of a range is equal to a number in a bank say in the region of 61 - 80 a specific text is instead shown say "Client A", but if the sum fell in the region of 51 - 60 that a different text would show, for instance "client b", is there such a way or how would you go about it? I've used if sum's before but never to highlight a range. Thank you, Alastair.

looking to highlight a cell that matches with a different cell. Then have a count of the matches sorted. The attached files works well for 6, but I now need to increase it to 10

I need a code so that when I click on a cell in one column it will highlight a cell on the same row that has a value in it. And then when I click off of it, the highlight goes away.

i need a code so that when i click on a cell in my first column, and cell in the same row will be highlighted, then when i click off of that cell in the first column, the highlight goes away. Can you show me excel highlight active row?

I need to match numbers in two columns and then if the numbers match, one date needs to be larger then the other date. I would like to highlight the cells where both rules are successful.