Trying to color an excel row based on list

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Trying to color an excel row based on list

KavyaL
Unladen Swallow

Posts: 4

Threads: 0

Joined: May 2020

Reputation: 1

May-19-2020, 10:35 AM

Hi john,
I think this would help you in coloring entire row instead of individual cell

for y in range(1,max_column+1):
ws2.cell(row=ro,column=y).fill = lightblueFill

Find

Messages In This Thread

Trying to color an excel row based on list - by curranjohn46 - Oct-04-2019, 10:30 PM

RE: Trying to color an excel row based on list - by Aurthor_King_of_the_Brittons - Oct-08-2019, 04:16 PM

RE: Trying to color an excel row based on list - by KavyaL - May-19-2020, 10:35 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Copy Paste excel files based on the first letters of the file name	Viento	2	423	Feb-07-2024, 12:24 PM Last Post: Viento
	unable to remove all elements from list based on a condition	sg_python	3	424	Jan-27-2024, 04:03 PM Last Post: deanhystad
	Search Excel File with a list of values	huzzug	4	1,216	Nov-03-2023, 05:35 PM Last Post: huzzug
	Turtle Star Fill Color Yellow-White Interchanging Color Effect	codelab	9	990	Oct-25-2023, 09:09 AM Last Post: codelab
	trouble reading string/module from excel as a list	popular_dog	0	416	Oct-04-2023, 01:07 PM Last Post: popular_dog
	Color a table cell based on specific text	Creepy	11	1,959	Jul-27-2023, 02:48 PM Last Post: deanhystad
	Deleting rows based on cell value in Excel	azizrasul	11	2,618	Oct-19-2022, 02:38 AM Last Post: azizrasul
	list from excel	devilonline	4	1,365	Jun-22-2022, 11:00 PM Last Post: devilonline
	select Eof extension files based on text list of filenames with if condition	RolanRoll	1	1,509	Apr-04-2022, 09:29 PM Last Post: Larz60+
	Compare two Excel sheets with Python and list diffenrences	dmkfon	1	14,608	Oct-09-2021, 03:30 PM Last Post: Larz60+

Users browsing this thread: 2 Guest(s)

View a Printable Version

Trying to color an excel row based on list

User Panel Messages

Announcements