Forum Discussion
AUSTXCHICK
Jul 30, 2019Copper Contributor
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...
- Jul 30, 2019
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
SergeiBaklan
Jan 03, 2023MVP
Not sure I understood the logic. For such sample
formula for conditional formatting rule could be
=( ROW($C3) > ( XMATCH("start", $B$3:$B$12) + ROW($B$3) - 1 )) * ( ROW($C3) < ( XMATCH("total", $B$3:$B$12) + ROW($B$3) -1 ))
BMayldry
Jan 03, 2023Copper Contributor
Yes, that's perfect. I didn't think of setting a 'start' value cell for the upper limit, I was just trying to highlight everything above 'total,' but I can make it work with your suggestion. Many thanks!
- SergeiBaklanJan 04, 2023MVP
BMayldry , you are welcome