Excel Conditional Color Formating

By n00bst4r23 ·

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.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Conditional color formatting in Excel

by Peconet Tietokoneet In reply to Excel Conditional Color F ...

A few sites to look at:

Color Banding Rows In A Worksheet

Color Functions In Excel

Color Palette and the 56 Excel ColorIndex Colors:

Calculating values of coloured cells

Excel: Change the font color based on the value in the cell in Excel 2003/XP/2000/97

Related Discussions

Related Forums