The formula in the extra column was: If the date in A2 was less than (earlier) today then the cell would match the value in B2. In my example the highlight was triggered when the date passed. Have you attempted to make that solution work? Start with your simplest case. You will end up with three aditonal columns. This can be done by repeating the solution offered above. It is looking like you are now proposing three different conditions for three different highlights. The current version of iOS numbers does support conditional formating, but only shows UI for simple rules (like turning a number red when it's negative). The most recent version of numbers on Mac supports conditional formating rules. I have a spreadsheet I developed in Excel 2011 (Mac) and then converted to Numbers09 on the laptop. In order to highlight your cell there we needed to create an extra column and recreate the formatting when your conditons are met.Įxcel Spreadsheet App With Support For Conditional Formatting Jun 16, 2011. Hi pobiom, As you can see in this thread, Numbers does not have a way to adopt the formatting of one cell to another. › ♥ Numbers App For Mac Conditional Formatting
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |