Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formating using formulas
Hi everyone
Does anyone know how to create formulas to display the word "High" in the color blue (bolded) with profit margins over 40%? I know how to apply conditional formating, but it asks to apply conditional formating to different cell, not the cell that contains profit margin information. For example: Column A contains information about profit margins, but I need to apply conditional formating to Column B. Please help me, I am getting crazy:( |
#2
|
|||
|
|||
Conditional formating using formulas
Add High to each row in column B, in blue bolded
Select those cells, say B1 down) and then in CF, use a formula (change condition 1 ) of =$A1<=.4, and format the text with a font colour of white -- HTH RP (remove nothere from the email address if mailing direct) "arifnj" wrote in message ... Hi everyone Does anyone know how to create formulas to display the word "High" in the color blue (bolded) with profit margins over 40%? I know how to apply conditional formating, but it asks to apply conditional formating to different cell, not the cell that contains profit margin information. For example: Column A contains information about profit margins, but I need to apply conditional formating to Column B. Please help me, I am getting crazy:( |
#3
|
|||
|
|||
Conditional formating using formulas
Thank you Bob
I tried this and did not work I will write down the whole thing in column A I have 64% 40% 30% -15% In column B display the word "High"in the color blue (bolded) with profit margins over 40% , "Low" in the color black (bolded) with profit margins between 0% and 40% inclusive , and "Loss" in the color red (bolded) with profit margins below 0%. Thank you |
#4
|
|||
|
|||
Conditional formating using formulas
This issue will require 2 steps. First in column B for each row place the
following formula: =IF(A20.4,"HIGH",IF(AND(A2=0,A2<=0.4),"LOW",IF(A 2<0,"LOSS",""))) Next for each cell in column B apply the following conditional formatting: Condition 1 - cell value is equal to HIGH -format BLUE & BOLD Condition 2 - cell value is equal to LOW - format BOLD Condition 3 - cell value is equal to LOSS - format RED & BOLD These 2 steps should accomplish what I think you want. Bill Horton "arifnj" wrote: Thank you Bob I tried this and did not work I will write down the whole thing in column A I have 64% 40% 30% -15% In column B display the word "High"in the color blue (bolded) with profit margins over 40% , "Low" in the color black (bolded) with profit margins between 0% and 40% inclusive , and "Loss" in the color red (bolded) with profit margins below 0%. Thank you |
#5
|
|||
|
|||
Conditional formating using formulas
Thank you very much
That's what I need exactly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Conditional Formating & Rand() function | Excel Discussion (Misc queries) | |||
how can i use colors in conditional formulas if i want the result. | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |