In the sub-menu, click "Conditional Formatting".Ĥ. Highlight a range of cells in the first row in the desired range of cells.ģ. In this example, I wanted to use VLOOKUP to determine a relative value in order to determine the desired format relative to the row.ġ. Below is my attempt to give you a step-by-step solution. I figured out a way to do what you would like. You can select the green checkmark icon at the same time. If this answered your question please go to your first post use the Edit button and add to the start of the title. You could help other users of the forum if you go to your first post and change the title from "Formulas for an entire row" to "Conditional Formatting for an entire row", which I think will be easier to find for people with similar situations. Note that there is a $ before the column letters but no $ before the row numbers. Using formulas and cell references in Ten concepts that every Calc user should know if you don't know what the $'s in $A2:$H2 mean. I typed A2:H28 in the name box of the formula bar, and used Format → Conditional Formatting → Formula Is → COUNTIF($A2:$H2 "No")>0 to give this condition a style with a cell background color. Crusader wrote:You may need code if you want to color the entire row.No code is needed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |