## Conditional Formatting

Hi there, I have a roster where i want to implement conditional formatting. If you see my roster below, you will see the green and red …

Hi there, I have a roster where i want to implement conditional formatting. If you see my roster below, you will see the green and red …

I have a list of users and their shared mail boxes they use within their departments. There are some mailboxes shared within one or more department …

The first table is the input table. The second table is the for the results. The result should display as follow: – If the end date of the …

Hi, I am just wondering why my IF function is not working correctly. Any help is appreciated. By:

Hello, Please could you help. i need a formula for IF Column B had data in and Column J is Empty then do this …

Hi, I am tryign to combine a VLOOKUP function and an IF statement. Basically I want to quality check pricing for a product using an ID number, so do a …

Hi, I’m trying to run an if function in excel which will add up the numbers in one column depending on the values in 2 other columns. The 3 …

Hello Everyone I want to ask a question relating excel 2013. I have 2 columns A and B respectively.Now my question is that suppose there are 2 vaues. In column …

Hi I need to create the following formula in Excel – please can you help! If A2 is less than 5 OR A3 is equal to or greater than 3, then A4 should read …

I have column a which has dollar figures in it. I have column b which I want to have a formula to fill in. That would be If amount in column a is less than …

I am trying to create a spreadsheet which matches a Child’s date of birth to their school year. For example: Date of birth Year group 1 September 2008 to …

Having a bit of difficulty determining where I’m going wrong but here is what I’m trying to do: I have a column labeled “Category” and …

Help Please! I have the following information CAT 1 CAT 2 SUP 1 SUP 2 AVERAGE MARK 48 55 67 50 50 30 61 87 I need to …

I have 2 criteria. If sales in a cell A1 are between 2500 and 4999.99, then in Cell B1 show 500, but if sales are greater than 4999.99 then show 1000 …

I have a spreadsheet which requires some additional formula inserted. I need the formula to read cell a and if it meets a particular requirement to then …

Hi, I hope i explain this properly, i am going to give you an example below. If D3 = 1 to 50, D4 needs to = 1 If D3 =51 to 100, D4 needs to = 2 this continues …

I was able to count cells by their background color by the following: Function CountColour(rng As Range, clr As Range)Dim c As RangeFor Each c In …

I’m working on a sheet that has a calculated date (i.e., condition met, date +/- days = result). I don’t need the day field, but do need to …

Hi, I am look to make my data entry spreadhseet a little neater. I have two columns of data with a column to the right to list the maximum value between them. …

Hi – hope you can help. I have a spreadsheet with the following columns a) Qualified b) Finished c) Length of Partnership (there are other columns but …

Hi Hopefully you can help me please. I need to add either 90 days or 180 days to a date (for this example say this date is in cell A2). Whether I add 90 …

Hi I was wondering is the following is possible to perform So i have an if statement and was wondering when the if statement is satisified and therefore …

What have I done wrong here? =(IF( E16,(G15+E16))(F16,(G15-F16))) to add or deduct from a balance.

I need a formula that will do the following: If the current target is within 33% of the proposed target, increase/decrease to the proposed target, if the …

The IF function has the following syntax: IF(logical_test,value_if_true,value_if_false) My questions is,If I don’t want the function to take any action …

I have 53 week numbers along columns AE to CE In column I is the total Quantity. In column Y is the start week number – 7 in this case. In column Z is …

Hopefully you have come to this post after reading my previous article about using IF functions in Excel. This is a next step to using IF in Excel. …

The IF Statement in Excel is a good tool, but is quite often little understood by Excel users. The IF statement tests a value and then says whether it is …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.