text colour

  1. M

    IF statement to return a text string linked to conditional formatting

    Could you please advise if its possible to have an IF formula statement in cell B7 when two conditions are true, one of which is using conditional formatting (red bold text based on a formula condition in another validation cell)? <tbody> A B 1 NAME TITLE 2 Mark Manager 3 4 NAME...
  2. S

    Formatting changes when opened by other users

    Ok, this is weird and driving me crazy :confused: I have a spreadsheet that has a list of the items a user has used the UserForms to put in. Part of the data they have to put in is a formula to calculate accessories for some parts. I don't want to have to hide/unide the column with the...
  3. T

    Multivlookup

    Hi all, I'm new to this forum but hope you can help me out! I have created a calendar in Excel that works by using a 'multivlookup' function that I have defined as; Public Function MultiVLookup(MatchWith As String, TRange As Range, col_index_num As Integer) MatchWith = LCase$(MatchWith) If...
  4. M

    Can I delete ONLY black text from within cells?

    Hi guys, I have a table of 280 rows with around 12 columns. I have marked certain parts of text in one column with different colours to represent products of particular interest. There are five colours used and I set these in MS Word. I'd now like to remove all text that is not one of these...
  5. S

    Find $ and hight only $ in red in excel vb or macro

    i need to find $ and high light only $ in red colour
  6. ClimoC

    Is this possible? Copy Cells with different text colours?

    'Ello... Situation: 2 sheets with tables of info, variable text lengths in each cell. Each 'line' in each cell is separated with carriage returns (crlf's/chr(10)'s). My script compares the first 4 characters after each crLf with the corresponding characters in the other sheet. If they are...

Watch MrExcel Video

This Week's Hot Topics

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
Top