Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format based on Other Cells
Spreadsheet with 4 columns and many rows. Two columns of data, third column
is a variance (A-B), fourth column is % variance (Column 3 divided by column 1). I have an input area where a user can input a dollar and % variance. I want to highlight the rows where both the dollar and % variance limits have been met. The calculated variance can be both positive or negative. For example, column 1 = salary $50,000, Column 2 = salary $75,000, column 3 = $25,000 variance, column 4 = 50% variance. If someone were to input variance amounts of $10,000 and 10% in my input area, I want the cells in my example to turn yellow. I would also want the cells highlighted if the salary amounts in my example were $50,000 and $25,000 with variances of -$25,000 and -50% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on other cells | Excel Discussion (Misc queries) | |||
Conditional Format based on other cell's value | Excel Worksheet Functions | |||
Conditional format in merged cells. | Excel Discussion (Misc queries) | |||
Conditional Format based on contents of cell. | Excel Worksheet Functions | |||
How do I set a Conditional Format for ROWs based on the value of . | Excel Discussion (Misc queries) |