Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formating
I have cells in a worksheet that brings in numbers (linked to the cell)from
other sheets in the work book. The values being brought in a simple numbers, averaged from a small set of other numbers. All number formats are set to number, 0 decimal points. The roll up table is showing the correct, rounded values to the nearest whole number that are linked back to cells in the supporting work sheet. However, the problem appears to be that conditonal formating is looking at the worsheet values and applying the format to the un rounded values. For example, if I tell the roll up table to format red each cell that has a value between 3 & 3.99. The table shows side by side cells that both contain the number 3. However one cell is red and the other is not. If you go back to the cell of origin for each, it will show that the unrounded value for one cell may be 2.8, and 3.5 for the other. The condition is applied based on the decimal points, even though the origin cells are fomatted with no decimal places. Thanks in advance, Danny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Help using Conditional Formating of Entire Rows | Excel Worksheet Functions | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Conditional Formating when result is text | Excel Worksheet Functions | |||
30 Day Aging Report Using Conditional Formating | Excel Worksheet Functions |