Color the text in Column D and F rather than filling the cell bgcolor #9
Labels
bug
Something isn't working
excel sheet
good first issue
Good for newcomers
hacktoberfest
openpyxl
python
up for grabs
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 :)
The text was updated successfully, but these errors were encountered: