So if it's greater than 10 then the value of this cell will be the value of the cell that I want to highlight. In this third cell here I'm going to put a formula and I'm going to say IF and then test the cell I want to test. For instance if I want cell A2 to highlight if B2 is greater than 10 I can do it if I use a third cell as kind of a proxy. If so change the highlighting for this cell. So I can say is the cell equal to something or greater than something or less than something. Conditional Highlighting works by adding a rule that acts based a test of the current cell. For instance if I want the first cell here, A2, to highlight when the value in B2 is greater than 10 I can't do it. So typically you can't use Conditional Highlighting on another cell. There you could read more about it, join us and get exclusive content. MacMost is brought to you thanks to a great group of supporters. Today let me show you how to use Conditional Highlighting in Numbers to highlight an entire row based on the value of only one cell. Check out Use Conditional Highlighting Across a Whole Row In Numbers at YouTube for closed captioning and more options.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |