Forum Discussion
Conditional formatting for entire row based on data in one cell
Hello
Assuming that D is the column containing the status cells, and you wish to apply conditional formatting to rows 1:50, here are the steps:
1. Select any cell in row 1
2. Go to 'Conditional Formatting>New Rule>Use a formula to determine which cells to format'
3. In the formula field paste =$D1="Shipped", set the required format and click 'OK'
4. Go to 'Conditional Formatting>Manage Rules' and locate the rule you have just created
5. In the field 'Applies to' paste '=$1:$50', or just select the required rows, starting from row 1, then click 'OK'.
If you type the word 'SHIPPED' in any cell of the column D (rows 1 to 50), the entire row will be conditionally formatted
Hope this helps
Yury
Good morning,
Appreciate the guidance you provided on this thread. for some reason, I inputted the instructions and for some reason when I select "No-show" from the drop down on Column " F" the red goes down a row. So it is not highlighting the row that the drop down in in. Please advise and thank you Yury.
Most probably references in formula and in Apply To range are not in sync. For example
we use in formula reference with first row and apply to the range which starts from the second row. If to change on row 2 in formula, it works
I'm trying to do a similar type of formatting where a row is highlighted when the end cell says completed. It works fine for one row however when I add more to the range the entire range is highlighted despite only the first row containing "completed" in the appropriate column. How do I make it so the row is only highlighted if the cell in column E for that row says "completed"
Your screen shot reveals the problem. Your formula of =$E$2="completed" has a cell reference that is fixed (nonvarying) both for the column and the row; i.e., only cell E2 will be used, regardless of which cell the formula is applied to. You want a fixed column (E) but a varying row. So use a formula of =$E2="completed"
