In Part 1, I showed how to quickly apply conditional format to selected cells.
Now I’ll show that with very little more you can start applying some tricks, like highlighting rows based on the value in one of the columns.
This is very easy, but it requires a bit of practice with the rule manager.
To illustrate this, I created a table with data values
I selected the values in the age column and quickly applied conditional formatting making values larger than 30 red and pink
To familiarize yourself with the Rule Manger, you just need to pick it from the options
The best way to learn how to use the manager is to select a group of cells and quickly apply a format and then play with the rule manager
You have to be a bit patient and think about what you are doing. It all makes sense if you pay attention…
Going back to highlighting rows… here’s the trick.
Select the rule and click edit.
Change the rule type as shown below
Now the first trick
Careful about where the “$” is (refers to my example). The $ is locking the column position but not the row number.
Press OK. And now the second trick:
Extend the “Applies To..” selection to include all the columns in the table (A, B, C,and D)
Accept, and rows where age is >30 should be highlighted.
- You quickly create a condition
- edit the rule with the manager
- set the formula to compare the values in just one column (D)
- expand the rule to apply to the entire table
Does this make sense? Did it work?
Just in case, the example is in http://db.tt/cpDYasd5