![]() ![]() 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).Enter the Formula, =INDIRECT("g"&ROW())="X".Select "Use a Formula to determine which cells to format".Use the "indirect" function on conditional formatting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |