Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating
I have three columns. A contains actual values this month, B contains yearly
average, C contains sales target. I need to conditionally format column A if the value in A is 10% above the value in B and 20% above value in C. Also if the value in column A is below the value in B and C I need to colour it a different colour. Please help and thanks Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating
Use CF with a condition of Formula Is and formulae of
=AND(A1B1*110%,A1c1*120%) and =AND(A1<B1,A1<C1) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Bob" wrote in message ... I have three columns. A contains actual values this month, B contains yearly average, C contains sales target. I need to conditionally format column A if the value in A is 10% above the value in B and 20% above value in C. Also if the value in column A is below the value in B and C I need to colour it a different colour. Please help and thanks Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Conditional Formating | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |