yellow

Can someone help please? I have a list of boxes containing strings of text, I need to highlight any words appearing in these strings if they appear in my list... is this possible? For example: <tbody> Sentence List My motorbike is yellow yellow My car is red red car...

Hi - Please help, i have many sheets, in each sheet for Columns B to M, if there is values below 98 will highlight with yellow. kindly help with macro, so i don't need to manual in each sheet. Thanks in advance

Hello please help me with this: I have this: <tbody> apple red 20 max orange green 34 min banana yellow 56 max berry black 76 min watermelon yellow 40 min </tbody> I want this: <tbody> apple red 20 max orange green 34 min banana yellow 56 max berry...

Hello! I have an excel spreadsheet including a table with different formatted sections. Giving the large amount of data, I had to insert a new column (the yellow coloured one) to calculate supplementary results. Anyway, I need to keep the dimensions of the table by hiding only the yellow...

Hi all, I'm trying to create a conditional formatting in a column that will look to the value in the previous column to apply the traffic lights icons: green, yellow, and red. The idea is, if value equals or higher than reference value then green, if greater than 75% of that value then yellow...

I'm needing help with the Conditional Formatting - 3 Circle Icons. I am trying to get it to work based off a formula. Such if cell B2 is >= cell B3 it will be the green circle in cell B2. If it's 85%-100% it will be the yellow, or less than 85% it will be red. <tbody> Store Actual Plan 1...

Hello All, I need to create a macro that takes three parameters (tab name, Row# and Col#) i have them in three different columns. Then based on those three parameters find the correct cell and highlights it in yellow...Anyone has an idea how to simply do this?... Thank you very much,

hello everyone, i have a table that some of its cells are filled with yellow color i want to do this: if cellscolor = yellow then 'command endif what is the exact vba code for this statement?

Hi All, I write this code, does the job but seems long. Is there a shorter way to rewrite this code and still do its job? If ActiveSheet.Range("B2").Value = "Red" Then ActiveSheet.Shapes("shEAC").Fill.ForeColor.RGB = RGB(255, 0, 0) Else If...

Hi, I have something that seems it would be easy that I can't figure out and need some help. I have a Table that looks like this: A 1| COLORS 2| Blue 3| Orange 4| Red Yellow I want the user to be able to enter Green below Yellow and the table automatically sorts the data when the...

Hello , I want either Excel Formula or VBA code so that it can highlight everything in a column (Numbers, special characters, spaces, all foreign alphabets except English letters.) with some color(Red) and cell should be highlighted with Yellow color. Eg. Cell A1 contains word like "World@1234"...

hi all, is possible: i am on C1, if the value of A1 is equal to 50 then coloring the cell A1 with yellow color? something like this: =if(A1=50,colorcell(yellow), A1-B1) thanks

Hello I'm trying to use this code; 'Zeroise yellow cells Range("C8").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select For Each cell In Selection If ActiveCell.Interior.Color = "FFFF00" Then cell.Clear End If Next But it's not working for...

I have a grid that has some blank cells, some cells have data. Blank cells are always filled BLACK. Data cells are NOFILL until I complete a (separate, non-Excel, manual) action. Then I fill it with gray. I have conditional formatting that wraps this week's row in YELLOW - just as a visual...

Currently i am working with a spreadsheet that has 18 columns and i am checking the value of c10 cell and then highlighting the row based on that 1 cell. I would like to improve on this by adding a second color and a second cell reference. My vision is to check r1c5 and r1c10. And if c5 is >...

Hello, I'm looking for an Excel conditional formatting to help me achieve what I'm needing. I have a column of data, and I'd like each new cell of data entered to be represented by an icon set based on the previous cell data only (either red (increase), yellow (no change), or green (decrease)...

if I have a row of numbers in the C row and another set of numbers in the A row, how do I get it to color if a duplicate number from C matches an A number? like for example make it highlight it with the color yellow.

Hi, I got a sheet where each order are splitted into one row per item. I would like to collect all items from same order into one row - is this possible? FROM THIS: <tbody> Order Item 1234 Red 4567 Blue 1234 Yellow 4567 Brown 1234 Orange </tbody> TO THIS: <tbody> Order Item Item2...

Hello Everyone, I am currently trying to run this code and it seems a little bit buggy. It used to run before I close the my excel file but it is providing inaccurate computations specifically coming from (FRed, FGreen....etc.) Now, when I try to re-run the file (after restarting my computer)...