colored

  1. C

    Formula help, several steps

    Hi, Asked for help regarding below in a different thread but since it evolved to be very disconnected from the subject/title I am reposting it as a separate thread: Please see picture, https://imgur.com/28MVScU I want the formula to do the following: Divide the costs in col B with the number...
  2. A

    show the colored value of column in listview

    hi, everyone i have data in sheet1 from range (a:d) , userform contains listview and the column d containes values of colored green and red i would show the colored value of column in list view is there any code do that ?
  3. J

    Color every second Row

    Hi Is it possible to create a code that color every second Row with e.g. RGB: 221, 235,247 Two pages in the Workbook, "Data" and "FrontPage", should not be colored. The size ofthe Range on the sheets to be colored can vary in number of rows Range to be colored always starts at "A7" Regards Jorgen
  4. M

    Help with formula please.

    Hello everyone, My computer is Dell and my operating system is Windows 10. My goal is to be able to paste numbers in cells (in this example cells D2 to H2) and have appropriate numbers populate the target cells (cells above and below colored cells). I don't know the appropriate terminology to...
  5. G

    VBA code to change font color from red to black

    Hi all, I´m looking for a code that changes in all the workbook, all the text that is in red colored (red font), into black (black font). Would it be possible? Thanks in advance!
  6. T

    Colored numbers in Formula Bar

    Hello. Im new around here. I wasn't able to answer the question I was looking for by googling, so wondered if I'll find it her. Maybe someone will answer. I'm looking for a way to make in formula bar sum numbers to be colored, like here. I want numbers to have different colors. In example every...
  7. zookeepertx

    I THINK a worksheet change event is in order, but there might be a better way

    Hi there! A co-worker has a workbook to keep track of employees' HazMat training classes. When she adds a new employee to the list, their data gets highlighted green, lavendar or blue, depending on what region they're in. The master sheet is called HazMat Training and there are 3 more tabs...
  8. B

    Product sum for min, max and the colored cells in VBA

    Hi Someone who can help me figure out the product sum for min, max and the colored cells in A2:C9. The coloured cells have a colour index of 15 and 40. Preferably VBA code /Bilbon <colgroup><col span="3"><col><col><col></colgroup><tbody></tbody> <colgroup><col...
  9. B

    automatically input number in cell based on cell color

    My worksheet has over 100 rows. Each of these rows has 2 or more connected cells that are colored. I would like to automatically enter a 1 in the leftmost cell once it is colored and a 2 in the rightmost cell that is colored. This could be independent of the cell color
  10. countryfan_nt

    Make the the cells colored black, but the arrows colored Green or Red.

    Hello friends, Hope all is well! I have a format cell below. The cell displays values and an arrow. Is it possible to have the values black and the arrow colored? [Color50] #,##0▲;[Color3] #,##0▼ Thanks a lot in advance!
  11. M

    How to copy cell color of Main cell to another cell if they both have same values?

    Hi All, I have attached a screenshot to help everyone get a better view of the request since after experimenting with Conditional formatting with formulas, I can't hit the correct way to it. Row 11 acts like a calibration form, Persons 1,2 and 3 will answer either Yes or No. If Master says...
  12. M

    city not available in Excel maps

    Hi, I will use Excel maps for my data, but 1 city (Izmir) is not available in Turkey map. i write the name of the city right, all other cities are now colored except Izmir. How can i find the defined name in maps-turkey for Izmir. BR, Metin
  13. A

    approximately formula by %

    greetings all, i have fixed numbers on column A and numbers on column B. my question is.. how can i using formula that said 1-(if the number on B1 grater than number on A1 by 3%) result will be colored red. 3--(if the number on B1 smaller than number on A1 by 3%) result will be colored...
  14. M

    Select Last Colored Cell in a Named Range

    Hello, I am tiring to select the last colored cell in a named range based on a active cell background color. Can someone please help??? Thanks
  15. Emerlin

    Printing times in color seem very slow?

    Hi, I have some sheets with simple colored cells and text. No large graphic files - just standard excel shading. As I am typing this I am waiting on a one page sheet to print that is over 11 MBs what causes he file sizes to get so large and is there any way to shrink them or print faster...
  16. B

    Conditional Formatting

    I'm trying to conditional format a group of data and it seems to be working, except one cell colored the wrong way and I'm not sure why? D11 & E 11 are the first two columns which has 7 & 13. The one that didn't color correctly is towards the bottom which colored red. The two numbers are 9 and...
  17. T

    counting colored cells

    is there a simple way to add up colored cells on your sheet by rows or columns. how many yellows do I have in this row or column etc.
  18. T

    Find latest date of colored cells from a range of colored and no fill cells

    Hello, guys! I need your help on one project. <tbody> V1 V2 V3 V4 V5 V6 12-Apr-2018 13-Apr-2018 14-Apr-2018 15-Apr-2018 16-Apr-2018 17-Apr-2018 </tbody> Let's assume V1, V2, V3, V4 cells are color filled with green, others are not. And I need to find the latest date from that colored range...
  19. P

    Cell gets colored

    Hello ! i have sheet and in that A we have lotid, is there any formula or code that when i punch bar code gun on that product that specific cell of that Lot id gets colored Thanks in advanced
  20. L

    Changing cell background based off values of cells on other worksheet w/ Conditional Formatting

    =IF(B2="X",IF(B3="Y", TRUE, FALSE),FALSE) then select the colored background if the condition is met works for me to get one colored background. Say 'Sheet2'!B2="X" I can set the cell background to Red for example. What if I also want the condition where 'Sheet2'!B2="Z" to shade the cell in...

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