another cell

  1. F

    Copy Formula Result & Highlight

    Hey All, Could you please kindly advise as to what's the best way to loop through cells and paste as value a result from formula in another cell? If the result was copied, the cell should also be highlighted in yellow. In short, formula in column AY throws a desired result or states FALSE. If...
  2. V

    Populate one cell based on another

    Hello All, I am looking for code to do the following... 1. Find the column (in row 1) named "Customer Number" 2. Find the column (in row 1) named "Model Number" 3. Find the column (in row 1) named "Model Color" 4. For every cell in the "Model Number" column named "Sky", populate the cell in...
  3. P

    VBA if cell value is greater than another cell value then syntax

    I am struggling to find any solution to my specific need online. I am tying to find the correct syntax to do the following: I want to create a macro that increases the value in one cell (W9) by 25 providing it doesn't go over the value in another cell (W7). I then want to create a second...
  4. M

    Exclude cells from 3 point colour scales based on text in another cell.

    Hey everyone, In column 'G' I have set up a 3 point colour scale based on the date. I want some of these cells to be excluded from this calculation based on the corresponding cell in column 'E'. So the rule I'm trying to create should go something like this: If E5 = "Action Taken" Exclude G5...
  5. M

    Populating 1, 2, or 3 cells to the left with text of any cell that contains a specific value (test also)

    Hi all, hoping to get some help with this. I am establishing an availability table in Excel. I have dates listed by day across the top of the spreadsheet and people listed down the left. In the table I have the date that the individuals arrives on shift marked as AR and the day that they...
  6. E

    Enter set value depending on data in another cell

    I wish to automatically fill in column 'B' depending what someone enters in column 'A' For example, if someone enters the value '43' in column 'A', then I want column 'B' to automatically enter '100,000' Column 'A' is using Data validation, therefore has a limited field of entry (see attached...
  7. G

    Can I do this in a formula, is VB needed?

    I'm setting up a form for people to enter information into. I have a free-form text field that users need to be able to type into, so I can't put a formula into it. However, I want a value to be "injected" into it upon a certain condition based on a formula from another cell "watching" that...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top