Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
achoudh5 opened this issue Oct 2, 2020 · 2 comments
Open

Comments

@achoudh5
Copy link
Owner

achoudh5 commented Oct 2, 2020

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
Copy link

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

@achoudh5
Copy link
Owner Author

achoudh5 commented Oct 3, 2020

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 :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants