| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i format cells in excel to show difference in payment amt
I have a set rental amount that the customer pays, but they may pay part of
that, I want to format the cells in excel to show that the full payment was not made. Anyone know how???? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i format cells in excel to show difference in payment amt
Look at Conditional Formatting
Compare Rental Amount vs Paid amount and set cell background if not equal With Rental value in A1, Payment in B1 then set CF for B1 as Formula is: =B1<A1 and set pattern colour HTH "Blue Eyes in South Ga." wrote: I have a set rental amount that the customer pays, but they may pay part of that, I want to format the cells in excel to show that the full payment was not made. Anyone know how???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show % Difference between two numbers | Excel Discussion (Misc queries) | |||
| Format Cells to show different values | Excel Worksheet Functions | |||
| How to format cells to show dates as the week-ending date of that | Excel Worksheet Functions | |||
| Merge cells in Excel 2003 doesn't show up on Format Alignment | Excel Discussion (Misc queries) | |||
| How do you work with drop down list to show a name, diff payment? | Excel Worksheet Functions | |||
Linear Mode
