text colour

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...

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...

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...

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...

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

'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...