| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Total cells of one column based on the values in another column?
Use Formula IS D164/not equal to/G162
"Riccol" wrote in message ... I'm trying to put a double-check in place and as easy as it seems it ought to be, I can't get it to work right. D164 - formula is =SUM(D160:D163) G162 - formula is =G40+G80+G120+G160 (This cell is a merged cell, so it's actually cells G162 and G163) To double check that the values of D164 & G162 match, I'm trying to add conditional formatting to D164. I've tried: Cell Value IS/not equal to/G162 and Cell Value IS/not equal to/G163 and Cell Value IS/not equal to/G40+G80+G120+G160 The format should be red and strike-thru if values don't match. The values DO match, but for each of the above conditions I tried, the number in D164 is shown in red and strikethru. What am I doing wrong? (Besides using merged cells, which I see from reading here is frowned upon.) Stu wrote: As a double check, you could set up totals for E5 thru E100 and for the derived sums for the individual companies, and set conditional formatting to colour the cell red if these do not match??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Discussion (Misc queries) | |||
| Resetting values based on change in cells of other column | Excel Discussion (Misc queries) | |||
![Stu[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
