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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting on sales percentage
Not very sure on your logics as posted, but for these lines
If the cost of A2 (selling the clothes) is < 40 % of B2 .. I would like a conditional format to have cell A2 turn red you could try it as Apply CF with A2 selected, using Formula Is: =AND(A2<40%*B2,A2<"",B2<"") Format as red ok out -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Loadmaster" wrote: 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. |
Reply |
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 |