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
Hello SergeiBaklan . I saw your numerous responses in another discussion. I'd be grateful if you can help me.
I wish for a row to become highlighted if one cell on this row in column Y: 1) has a date and 2) the date is today or in the past.
Thank you!
Let's say you want to apply this to rows 2 to 100.
Select these rows; the active cell in the selection should be in the top row (row 2).
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=AND($Y2<>"", $Y2<=TODAY())
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.Hi - hopefully it is ok if I ask you the same question. I am not sure if the other user is still active. It is below.
Thanks!
Hey there,
Your solutions are awesome! Could you help me understand why my last row keeps being excluded from my conditional formatting? Even if I add all rows $J:$J a specified number of rows $1:$3000, it keeps excluding the last row when I adjust the sorting. For reference, I am conditionally formatting columns A through J based on the text in column K.
- Worked perfectly. Thank you!
