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
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
Could you please illustrate the question with small sample file - it's not clear where is the number, where are values as shipped, do you use range or table
Hello Sergei, it seems like you have many helpful answers, hopefully you can help me too.
My situation is as follows:
A sheet with in column A the dates, a date may or may not occur more then once. In column B names, in column C a start time, D end time, etc (it is basically a calendar).
I want the first instance of each date to have a line above it, so each day gets separated by a line, making the sheet more readable. I want this line to extend over the entire row, or at least the once with data in it.
I use the formula countif($A$1:A1,A1)=1 to find the first instance of each date. This works perfectly, but only for column A. When I apply this formula to my range, the formatting will look at each column separately, and put the line above each first occurrence of every value, instead of extending the line from column A. Is there a way around this?
Thanks,
Elgar
I am building a shipping tracker, and I am trying to have the entire row highlighted when column AD is > 10%.
ItemCode TourDesc WhsCode Quantity QTY LOG CITY QTY LOG CITY Balance %age Owed CHG134806-S BLACK T AMERICAN FLAG TOUR 24 MAY ITIN UPDATE TRD 72 0 157921 Maryland Hghts 72 157924 St. Paul 0 0.00% CHG134806-M BLACK T AMERICAN FLAG TOUR 24 MAY ITIN UPDATE TRD 288 72 144 72 25.00% CHG134806-L BLACK T AMERICAN FLAG TOUR 24 MAY ITIN UPDATE TRD 504 144 144 216 42.86% CHG134806-XL BLACK T AMERICAN FLAG TOUR 24 MAY ITIN UPDATE TRD 648 144 72 432 66.67% CHG134806-2XL BLACK T AMERICAN FLAG TOUR 24 MAY ITIN UPDATE TRD 432 72 72 288 66.67% CHG134806-3XL BLACK T AMERICAN FLAG TOUR 24 MAY ITIN UPDATE TRD 216 0 0 216 100.00%
