Conditional formatting help required

[ksnexcel]

Oh ok. there would be atleast 3 levels of listing.

 

[NARAYANK991]

Hi ,

Give me some time to think this through.

Narayan

 

[NARAYANK991]

Hi ,

See the attached file. Columns E , F and G are the added helper columns.

Narayan

 

[ksnexcel]

1) If I enter -2 in C4 it is not painting in c3.
2) positive direction is not working.
3) may be we can simplify for one level.

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[ksnexcel]

Sorry was away and unable to check earlier. Looks good. Thanks a ton!