Please help- conditional formatting

Closed

chdm2013 Posts 1 Registration date Tuesday June 25, 2013 Status Member Last seen June 26, 2013 - Jun 26, 2013 at 12:51 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 2, 2013 at 10:42 AM

Hello,

I want help to solve below described question for excel 2007.

CELL A1= 01-JAN-2013, A2= 02-JAN-2013, A3= 05-JAN-2013, A4= 07-JAN-2013, A5= 09-JAN-2013, A6= 10-JAN-2013

Here a1 and a2 has difference of 1 day so both the cells a1, a2 should be highlighted with same color (blue), cell a3 and a2 has more than 1 day difference so cells a3 should be highlighted with separate color (cell a3=green), cell a4 and a3 more than 1 day difference so cells a4 should be highlighted with separate color (orange).

Thanks in advance for help.

Kind regards.
Chirag

Please help- conditional formatting
Excel formula to change cell color without conditional formatting - Excel Forum
Apply conditional formatting to the selected cells ✓ - Excel Forum
Excel conditional formatting if cell contains multiple specific text ✓ - 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
How to clear formatting in excel - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
Jul 2, 2013 at 10:42 AM

Hi Chirag,

Conditional format, Formula is:
Rule 1: =A2-A1=1
Rule 2: =A2-A1>2
Rule 3: =A2-A1>1

Apply desired format to each rule.

Hopefully I understood you correctly.

Best regards,
Trowa

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

one cell will turn green when the two other cells match

Conditional format based on another cell containing text

Similar discussions

Subscribe To Our Newsletter!