Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF ? function
I need to subtract one cell from another and if the sum is 3000 or over, I
want the cell to be red. I need a function to do this. I'm a newbie so please if you answer give me the complete function. Thank you, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF ? function
Greeneyez2 wrote:
I need to subtract one cell from another and if the sum is 3000 or over, I want the cell to be red. I need a function to do this. I'm a newbie so please if you answer give me the complete function. Thank you, You can use Conditional Formatting. Select the cell with your sum then from menu Format, Conditional Formatting, under Condition 1 select "Value is" tehn in the next drop down select "upper or equal" then type 3000 in the text box. Click on Format, select the format you prefer then click OK twice. And the job is done... -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF ? function
You need conditional formatting on that sum. Change the condition in CF to
formula is, and use a formula of =$A$1-$B$1=3000 and set the colour to red See http://www.contextures.com/xlCondFormat01.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Greeneyez2" wrote in message ... I need to subtract one cell from another and if the sum is 3000 or over, I want the cell to be red. I need a function to do this. I'm a newbie so please if you answer give me the complete function. Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |