Hi pobiom, As you can see in this thread, Numbers does not have a way to adopt the formatting of one cell to another. In order to highlight your cell there we needed to create an extra column and recreate the formatting when your conditons are met.
Excel Spreadsheet App With Support For Conditional Formatting Jun 16, 2011. I have a spreadsheet I developed in Excel 2011 (Mac) and then converted to Numbers09 on the laptop. The most recent version of numbers on Mac supports conditional formating rules. Mac-torrent for windows. 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).
It is looking like you are now proposing three different conditions for three different highlights. This can be done by repeating the solution offered above. You will end up with three aditonal columns. Have you attempted to make that solution work? Start with your simplest case. In my example the highlight was triggered when the date passed. 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.
If B2 and C2 matched then the highlight is applied. So design your formulas to reflect the cases you want to test for. Hi pobiom, As you can see in this thread, Numbers does not have a way to adopt the formatting of one cell to another. In order to highlight your cell there we needed to create an extra column and recreate the formatting when your conditons are met.
It is looking like you are now proposing three different conditions for three different highlights. This can be done by repeating the solution offered above. You will end up with three aditonal columns. Have you attempted to make that solution work?
Start with your simplest case. In my example the highlight was triggered when the date passed. 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. If B2 and C2 matched then the highlight is applied.
So design your formulas to reflect the cases you want to test for. Vestax spin software download. Three conditional highlighting rules can be accommodated with a single auxiliary column, as shown below.
(The small table, showing today, is included only to show the current date when the screen shot was taken, and is not used in the solution. Column C contains this formula: C2: IF(B. Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only.
Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.