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
Your screen shot reveals the problem. Your formula of =$E$2="completed" has a cell reference that is fixed (nonvarying) both for the column and the row; i.e., only cell E2 will be used, regardless of which cell the formula is applied to. You want a fixed column (E) but a varying row. So use a formula of =$E2="completed"
Hello!
I am struggling with getting multiple CF rules to run in sequence. My goal is to have the row color change as new information is entered into specific cells in specific columns. However, I don't know how to write the formula.
CF iterates ranges cell by cell, apply to the cell formatting for the first rule which returns TRU and ignores other rules:
If we change rules order that will be
Depends on your goals use according order of rules.
- The goal is to have the row change color three times. First when the date is entered into Column E, then again when a date is entered into Column J, and finally when text is entered into Column M.
In this order the colors should go from Yellow to White, White to Green, and Green to Grey.
The issue seems to occur when trying to get the row to change to grey from green after entering text into Column M. It just stays green as if it can't perform the last rule.
So, I feel I maybe missing something in my formula or perhaps not using the right one(s).
