Now this may differ from time to time since I do a monthly follow-up. I would the calculate like this: 159 - 10 = 149 Then: 149/159 = 93,710ĩ3,710 is the percentage value I am after. Lets say that out ofġ59 rows/cells there are 10 that are red ( did not match the reference value in column A). If I would do this manually, I would take the total number of rows ( 159), substract with the number of rows (cells) that have turned into red ( not matching the target value in column A). Then choose the menu Conditional Formatting> New Rule option Format all cells based on. Now, what I would like to do, is to automatically calculate what the percentage will be of the total. In Applies to, change the range that corresponds to your. If the cell value inī1 is equal to or greater than cell value inĪ1, the cell turns green ( background). 'Format cells if', select 'Custom formula is' and. Next to values in the selected range, click unique or duplicate. Point to Highlight Cells Rules, and then click Duplicate Values. On the Home tab, click Conditional Formatting. Select 'Custom formatting' from the Format menu. Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. It's a reminder that some Googling is always worthwhile before asking a new question. On all the cells in column B, I have conditional formatting setup. In particular Conditional formatting based on another cell's value and the answer (with the attached comments) by Zig Mandel. In column B, spanning from row 1 to 154, I have also a percentage value that I have copied from another source. In column A, spanning from row 1 to 154, I have a percentage value entered, what I call a target value.
I have an Excel sheet were I compare a bunch of cells.
0 kommentar(er)
