Forum Discussion
Solved
Conditional formatting for entire row based on data in one cell
I need all cells in a row to highlight a certain color if the data in one cell contains a specific word. What I specifically want is for an entire row to turn grey if the status cell contains th...
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
I created a conditional format for a range of cells to highlight if the cell contents for cells outside of the range match specific text. The formula is =$T2="YES" and the range is =$A$2:$N$500. My problem is one row is highlighting when the value is "NO" but all other rows are not highlighting with a "NO" value. How can I troubleshoot that? Here are some screenshots to help. I have some CF statement selected to Stop if true. Also, one cell in that same row does not highlight to make it even more interesting.
Screenshots:
All rules with full range selected
All rules with just problematic row selected
All rules with just the one cell that does not highlight in the problematic row
Cell T20 = "NO" therefore the row (A20:N20) should not highlight green, which it is. Furthermore, cell K20 is not highlighted. All other rows where the contents of column T = "NO" are not highlighted within the range.
HELP?!?!?
Thanks
Tim
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- Hi Hans,
I'm new to this community. I don't see a way to attach my sample file to this post. Is there a means for me to share it with you? There are formulas that won't be captured by a screenshot.
Thanks,
Tim
