search

achoudh5 / Manipulating_Excel_Sheet

Real world application of Manipulating Excel Sheet using python.
Apache License 2.0
8 stars 14 forks source link

Color the text in Column D and F rather than filling the cell bgcolor #9

Open achoudh5 opened 4 years ago

achoudh5 commented 4 years ago

If you check the Hacktoberfest_Inputt.xlsx you will notice that each cell can have single or multiple entries. Based on the current logic, each cell in columns D and F gets colored with the last returned color for last value if there are multiple.

The requirement is to color the text of each cell value with the corresponding returned value so that if there is a case where two values in a cell have different values, I can easily distinguish.

Ex. In column D we have below cell value:- 1.2.11.3,1.2.11.5, 1.2.11.5 1.2.12.1 1.2.12.4

Expectation:-

if 1.2.11.3 returns a green color after checking from Hacktoberfest_database.xlsx then, it should color itself with green color. Similarly, if 1.2.11.5 returns blue , it should color itself as blue . All colors should correctly mapped if that makes sense.

If no entry for an input is found in the database, keep it black in text ie do nothing to text color.

For any questions, please comment on this issue and I'll reply asap :)

Vortex2wenty commented 4 years ago

Hi, I would like to claim this issue for the 2020 Hacktoberfest. Thanks.

achoudh5 commented 4 years ago

Sure, @Vortex2wenty . In the spirit of Hacktoberfest, I'll keep the issues opened and welcome all PR's. If your PR suffices the required set, I'll merge it. Thinking Continuos Improvement :)