Colour Object Based On Cell Content?

Mar 22, 2011

I have a circle object on an Excel spreadsheet(I used "Insert", "Shapes" to put it there).

I would like to change the colour of the circle object based on the contents of cell A1.

Cell A1 will be "Red", "Yellow" or "Green".

If I type "Green" into cell A1, then I would like the circle object to change to green.

If I type "Yellow" into cell A1, then I would like the circle object to change to yellow....

View 9 Replies


ADVERTISEMENT

Setting Colour Of Cell Based On Content

May 3, 2007

I have inherited a spreadsheet from someone else that rather cleverly (in my humble opinion) sets the colour dependant on the contents. ie negative value is red, zero is amber and positive is green.

i like the idea and would like to use it on a spreadsheet of my own, but have tried to find out how it is done and can't!

View 9 Replies View Related

Return The Colour Of A Cell As Well As The Content In A Vlookup

Feb 20, 2008

This is probably really basic but can anybody tell me how to return the colour of a cell aswell as the content in a vlookup??

View 9 Replies View Related

I Want A Certain Object To Change Colour When A Certain Cell = Something

Apr 17, 2007

I dont understand how this event works.

I want a certain object to change colour when a certain cell = something.

View 9 Replies View Related

Change Object Colour And Rotation Depending On Cell Value

Apr 11, 2014

I would like to conditional format an Object depending on the variance between 2 weeks.

If the value is > than 0% the arrow is Green and points upwards.
If the value is = to 0% the arrow is Yellow and points at at 90 degree to the left.
If the value is < than 0% the arrow is Red and points downwards.

Attached is a sample : rrow Conditional Format.xlsm‎

View 4 Replies View Related

VBA Code To Colour Certain Cells Based On RGB Colour Shown In Cell A1

Apr 17, 2014

I have a lookup that gives and RGB colour code in Cell A1; for example 186, 206, 140.

I'd then like Cells R10:V15 to fill with the RGB colour based on the result in A1.

View 2 Replies View Related

Change Content Of One Cell Based On Content Of Another

Apr 18, 2014

Formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the same row.

Example: cell in column D says "PSA" - so I would need the cell in column H for that same row to read "Radio"

I would need an entire sheet scanned to review for these occurrences and make the appropriate changes. I also would need the formula to be inclusive enough to scan for variations in column D cell content (PSA 1, PSA 2, etc).

View 4 Replies View Related

Add Value Based On Cell Content

Mar 18, 2009

I have a named range (D:16 F:800) called NameRange which contains names.
Id like to create a macro which offsets a letter x, 10 columns to the right everywhere that name appears within the range. As an example: If Im trying to find the name Tom, A dropdown menu shows the name Tom ( which Ive created) whereby it calls upon a script to search within the named range from this:

Bob Kim Tom
Tom Sue
Mary Bill Ted
Tom Sue Bob
Fred Bill Sue
Bob Tom Kim

and offset x to look like this:.......

View 4 Replies View Related

VBA Cell Colour Based On The Value

Sep 24, 2009

I have a userform that outputs data to a worksheet. One of the textboxes contains either one of 3 values, either: N/A, Debit, or Credit. This textbox is called "tbDebitOrCredit".

What I need is, when the the user clicks the "Submit" button and the data is output to the worksheet, the cell that recevies it output from "tbDebitOrCredit" turns a specific colour based on the value.

For example:

N/A = White
Debit = Red
Credit = Green

View 2 Replies View Related

And / Or Function Based On Cell Content

May 8, 2014

I'm trying to obtain a result based on the number of characters in a cell. If the cell content is blank or contains 9 digits then leave blank.

Any other result must provide the outcome of "incorrect number supplied".

I've tried the following formula but it doesn't work.

View 3 Replies View Related

Hiding Row Based On Cell Content?

Jul 9, 2014

I am trying to search the cells in Column A around rows 54 to 77. And if the cell says "Yes" it should hide the row. I think I'm on the right track, but can't seem to get it work.

[Code] .....

View 6 Replies View Related

Message Box Based On Cell Content And Day?

Mar 18, 2012

I am working on a spread sheet for work were we have to test certain items on certain days, e.g. one item needs to be tested every Tuesday & Thursday, when the test is completed you click on a drop down box and click on completed or in progress.

What I would like are a couple of things to happen as follows:

A message box would pop up when you open the file to inform the employee that the test is due today only on Tuesday & Thursday if not completed or in progress from the drop down box. Once you select completed or in progress from the drop down box the message box no longer appears. Every Tuesday & Thursday when it's first open it deletes the cell content, thus triggering the message box test is due today, and once completed or in progress it no longer appears until next Tuesday or Thursday.

The spread sheet is on shared drive and used by several users, let's just say cell A1 is the cell I have the drop down box

View 1 Replies View Related

Run Macro Based On Cell Content

Aug 7, 2006

I have a drop down list made from the Forms toolbar with a list of items: 1, 2, 3, 4, 5. I have set it with a linked cell, so when you choose, say 3, from the dropdown, 3 appears in B10.

I was hoping to add a 'Go' button, which would run another macro depending on what is in B10, i.e. so if 3 was chosen, then you press 'Go', Macro3 would be run.

So I have 5 macros called Macro1 - Macro5, and I need some code for the 'Go' button which will run the right macro depending on what number is in cell B10.

View 9 Replies View Related

Colour Cell Based On Date ..

Feb 11, 2009

It's quite funny that i'm asking this cause I answered a similar quesstion earlier. But I can't seem to get my head around the thinking of this one.

I am trying to create a formatting so that if todays date is greater than the date in the cell the cell is coloured red. And if todays date is > today()-14 <today() the cell is coloured yellow.

I don't think it is as simple as using conditionaly formatting, it may well be but like I said I can't quite get my head around what I need to do.

View 8 Replies View Related

Sum Values Based On Cell Colour

Jun 18, 2008

Can you sum cells based on colour, and if so, how do you determine what code/number your colour is to input into the programming?

View 13 Replies View Related

Changing Row Colour Based On Cell Value

Sep 21, 2012

I'm trying to change the colour of a row based on the value in a cell (in a column) and am wondering how I can do that. Conditional formatting doesn't allow enough colours unfortunatly. Ive googled it and can only get a cell colour to change not a row colour.

To give an explanation:

Sheet 1: Rows 5 - 100 colour to change based on Sheet 2 Column K5-100.
Column K5-K100 will have values between 0 and 10.

View 4 Replies View Related

Count Only Based On Same Cell Colour?

Mar 20, 2013

I am trying to establish whether there is a excel formula which will allows you to just to count the cell with the same cell colour. I have made the below listed example to illustrate what I am trying to achieve:

A B C D E11/03
12/03
13/03
14/03
15/03
Total

[Code].....

In the there are total of two green colours, and one red colour to be counted.

View 3 Replies View Related

If Formula Based On Cell Colour?

Mar 21, 2013

I have a auto generated report that colours a certain column, that shows all the items that are in receiving error. I want to pivot the data and show the break down on the colours used; Green = newly added, Amber = escalated, Red = urgent

at the moment I'm adding a column next to it and filling it in myself. is there away to automate this? either via a custom forumla or marco

View 1 Replies View Related

Modify Cell Background Color Based On Cell Content

Jul 1, 2014

I am working on developing QR Codes using some MATLAB code and it would be really convenient if I could create an excel program which changed the background color of a cell containing a 1 to black and a cell containing a 0 to white.

View 2 Replies View Related

Using A Formula To Populate A Cell With Certain Data Based On Content Of Another Cell?

Jul 7, 2014

I am currently trying to create a spreadsheet whereby if I enter certain text in a cell in Column A on worksheet 1 that correlates with text in a cell in Column A on Worksheet 2, then the description in Column B in Worksheet 2 is entered into Column B on worksheet 1.

For example, if worksheet 2 has the following:

Column A Column B
XXXX PRODUCT 1
YYYY PRODUCT 2

and I enter XXXX in column A on worksheet 1, I want Column B on worksheet 1 to automatically enter PRODUCT 1.

View 5 Replies View Related

Multiple Find And Replace Cell Content Based On Another Cell?

Mar 25, 2014

multiple search match and replace content in a different column so for example

new workbook (look up table)
sku
search1
search2

[Code]....

so something like where you compare two tables and find and replace based on another cell that matches in my sku.. more details would be if the table column aren't exactly matching but the column header and the row header would match and fill or replace in the correct/corresponding cell is there a macro or vba to do this job in excel?

View 6 Replies View Related

Sorting Certain Worksheets Based On Cell's Content

Jan 22, 2013

I have standardized each existing worksheets and any new worksheet to have certain parameters. The purpose of the Macro requested is ensure these worksheets are sorted alphabetically (and only these worksheets). The code I have been working with is contained below. It is working as expected but now I need to incorporate a statement which places the following condition:

Sort worksheets only if A3 has cell value of eCRF NameIgnore worksheet name: TOC & ENTER ECRF NAME

VB:
Sub Sort_Tabs()
'declare our variables
Dim i, j As Integer

[Code].....

View 5 Replies View Related

Formatting Row Of Cells Based On A Cell Content

Feb 16, 2010

I want to format a range of cells based on the name listed in a cell in column A (starting @A6). I currently do this manually. It is to help me visually see the line I am working with and for what person.

I am almost certain that is going to take a VBA, but I know little to nothing about setting one up.

I have attached a sample. I am using Excel 2003.

View 7 Replies View Related

Asigning Variables Based On Cell Content

Sep 30, 2007

I just ordered vba for dummies, in the meantime I will have to get my info from the experts on this board. I want to use a name I have in a cell in a msgbox routine.

Currently I have

View 10 Replies View Related

Changing Cell Content Based On Button

Oct 14, 2008

I have created two buttons in a worksheet to navigate to two other worksheets. I would like a cell to display 'YES' automatically if one of the two buttons is clicked and or to display 'NO'. I also would like to change the colors of these cells change automatically depending on which button is pressed.

View 2 Replies View Related

How To Lookup Row # Based On Content Of Another Column's Cell

Oct 24, 2005

I have a 3 column table with 20 rows. The first two columns contain travel
expense data. The cells in the third column are blank exept for whichever
cell I enter an "x" in. Please let me what formula or worksheet function do
I use to calculate the travel expenses based on the data in the first two
columns that correspond to the row of the cell with an "x" in the third
column?

View 9 Replies View Related

VBA To Change Cell Color Based On Content

Feb 13, 2012

I have a large spring-selection table, which is populated with things like "4.88 x 635" and "5.26 x 584". There are 1520 fields in the table populated with any combination of the 432 springs available for selection. The spreadsheet takes my criteria, finds out which springs it's allowed to choose from, and populates the table. It could be 20 springs, could be 30. I'm trying to get the number down to 10. The table updates when I change the criteria.

What I'm after at this point is a macro which will color-code the table based on the cell contents, so that all the "4.88 x 635" have one color and all the "5.26 x 584" have another colour. Doesn't have to be any particular colour, just so long as it's a bit different to the cells around it. how the table reacts.

The biggest spring size is "6.93 x 1727", which could be converted to a color reference, perhaps by adding up all the digits, or taking out the non-digits and dividing by 123781, I don't know I'm thinking out loud. And then just assign the cell color to that number.

Where to start a macro like this. Obviously it would use ActiveCell.Interior.ColorIndex but I can't find anything like this on the web.

View 9 Replies View Related

VBA To Hide Rows Based On Cell Content

Jun 23, 2006

If I have data in range A1:Z99 I want to write a macro to hide all the rows that have a zero in the A column.

View 9 Replies View Related

Hide Columns Based On Cell Content

Apr 3, 2008

I'm sure this is an easy one, but I have never done this before. I need to know the best way to hide (for example) Columns U:W if cell U3 is blank.

View 9 Replies View Related

Lookup Data Based On Cell Content

Sep 9, 2006

I am setting up a worksheet (1) with a full list of part numbers supplied, cost etc. ie:

Part Description Price Qty
1234 Blah Blah 1.00 1
1235 Blah Blah 3.00 0
1236 Blah Blah 2.00 2

And I have set up a seperate worksheet (2) as an invoice. What I have been trying to do is when I enter a qty in worksheet (1), worksheet (2) will reconise an entry in the qty colum an copy selected fields/ cells. I can do a "=" or use an "if" statement looking at anything greater than "0". but is there a way I can get the invoice worksheet to ignore any lines with "0". So it will only copy over the information with only qtys for the invoice ?.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved