Question

Locked

Excel Conditional Color Formating

By n00bst4r23 ·
Hi,

I have a weird question related to Excel. I have a spreadsheet with over 100,000 entries. The columns are from A through K, while the rows extend to beyond 100,000. Almost all the entire column A is blank, except few of the entries have the text value "Yes". Basically, my objective is to color each and every row right below to the one that has the value "Yes" in its column A.

For example, if A6 = yes, then I want the row 7 to be colored as Red. Then, if A10 = yes, then I want row 11 to be colored as Red. And so on.

Do you guys have any suggestions as how to accomplish that? Thanks!

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Conditional color formatting in Excel

A few sites to look at:

http://tinyurl.com/azfuj6

Color Banding Rows In A Worksheet
http://tinyurl.com/bxwf26

Color Functions In Excel
http://tinyurl.com/chxxne

Color Palette and the 56 Excel ColorIndex Colors:
http://tinyurl.com/ywrkze

Calculating values of coloured cells
http://tinyurl.com/awot2y

Excel: Change the font color based on the value in the cell in Excel 2003/XP/2000/97
http://tinyurl.com/oq3qk

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums