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
I believe I have followed your instructions correctly, but the desired result only works in the first row.
The desired result is that any row from 5 to 500 that contains a qty other than zero in column F be highlighted.
Thank you in advance for your help.
I believe I went into conditional formatting and selected 'use a formula to determine which cells to format'. Then, I put $H1='N'. The $ keeps the column consistent while the row may change. So, in your case, it would be $F5>0. I am not able to troubleshoot this at the moment, but let me know if it works.
