| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting on sales percentage
I require a formula that if cell A2 has the cost of buying clothes. Cell B2
has the cost when selling clothes. If the cost of A2 (selling the clothes) is < 40 % of B2 (selling the clothes) I would like a conditional format to have cell A2 turn red. Hence, If sales on the clothes is 60 % of buying the clothes have a conditional format that will turn cell A2 green. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply various percentage with sales between a & b, b & c, etc. | Excel Worksheet Functions | |||
| Sales comparison percentage question | Excel Discussion (Misc queries) | |||
| Percentage of amounts and profits of individual sales | Excel Worksheet Functions | |||
| Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
| percentage of sales | Excel Worksheet Functions | |||
Threaded Mode
