Conditional formatting

Closed

barrywood Posts 1 Registration date Sunday October 4, 2015 Status Member Last seen October 4, 2015 - Oct 4, 2015 at 02:31 AM

Hello,
I am trying to format a column B2 to B56 with different dates in each row to change yellow when each date is 30 days before the due date and red when on the due date. Any row without data to stay white. I am using excel 2010.

Conditional formatting
Excel formula to change cell color without conditional formatting - Excel Forum
Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
Apply conditional formatting to the selected cells ✓ - Excel Forum
Copy conditional formatting but change reference cell ✓ - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Conditional format based on another cell containing text

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!