Previous Topic Next Topic

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

1 response

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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response
Conditional Formatting: 3 range of numbers
LCC -
LCC -

2 responses