![]() If someone still uses Excel 2007, press Shift + F10, S, T, Enter. In Excel 2016, 2013 or 2010, press Shift + F10, S, R, and then click Enter. Select the cell (s) to which the format should be applied. Press Ctrl + C to copy the selected cell to the Clipboard. If you're wanting the rows to turn different colours depending on what's entered in column C, just create several rules using the steps above for each possible colour, replacing the text in the inverted commas for each. Select the cell from which you want to copy the format. And you'd change the 'applies to' field to $A$2:$H$100. Your formula would be just =$C2="Text1" (the column should be absolute, the row relative, as RoryA mentioned). In the conditional formatting menu, choose the bottom option, 'Use a formula to determine which cells to format'. ![]() Let's say you want the entire row to colour red if you have the text "Text1" in column C, and you're applying the rule to the range A2:H100. Incidentally, this rule is probably the simplest to put together. ![]() Another way to do it is to select the row containing your format and autofilling down, choosing 'Formatting Only' from the popup menu that appears when you let go. ![]() To apply the formatting rule to the rows below, the easiest way is to go into the Conditional Formatting - Manage Rules menu, then edit the range in the 'applies to' field.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |