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 December 27, 2022 - 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 conditional formatting if another cell contains specific text - Excel Forum
How to clear formatting in excel - Guide
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
Excel formula to change cell color without conditional formatting - Excel Forum
Phone formatting software for pc - Download - File management

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Conditional formating - apply on more cells

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!