To set Conditional Formatting for an ENTIRE ROW based on a single cell you must ANCHOR that single cell's column address with a "$", otherwise Excel will only get the first column correct. You must start at G1 rather than G2 otherwise it will offset the conditional formatting by a row. Just select the entire sheet first, as conditional formatting only works on selected cells. Would be the correct (and easiest) method. Just change either the g column or x specific text in the formula and set different formats.įor example, if you add a new rule with the formula, =INDIRECT("h"&ROW())="CAR", then it will format every row that has CAR in the H Column as the format you specified. You can repeat this to do multiple row formatting depending on a column value. If there isn't an X in the column, the row won't be formatted. In the "Applies to" box of your new rule, enter =$A$1:$Z$1500 (or however wide/long you want the conditional formatting to extend depending on your worksheet)įor every row in the G column that has an X, it will now turn to the format you specified.Select "This Worksheet" if you can't see your new rule. ![]() Open "Manage Rules" in Conditional Formatting.Enter the Format you want (text color, fill color, etc). ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |