Auto Highlight Cell Based On Other Cell Value?

Dec 6, 2013

I'm having a difficult time making this work properly.

To simplify, I want:

cell A1 to fill with blue when cell G1=0 or greater.
cell A1 to fill with yellow when G1<0

Next step is to apply this to cells A1:A100 based upon cells G1:G100.

View 3 Replies


ADVERTISEMENT

Macro That Will Highlight Cell And Four Rows To Right Based On Text In Cell

Aug 6, 2014

I have a spreadsheet where if Cell A2 says "Deposit", Rows A2-E2 would be formatted with a Blue background.

I've tried conditional formatting, but I can't built it into a Macro (I can't make it run), and it only highlights the cell that has that value. I also tried having the spreadsheet filter down to only the values I want highlighted, then highlighting all cells and un-filtering the column- this didn't work either.

It would basically say :

If (any cell in Row A) has text = "Deposit" (it needs to be exact, it can't be "containing"), set cell with the word "Deposit" and 4 cells to the right as Blue (I'm not picky about the color).

View 10 Replies View Related

Highlight Cell Based On Value Falling Between Certain Range In Another Cell?

Feb 1, 2012

Let's assume Cell A2, A3, A4, etc, only contain names/text.

Then let's assume I have set up cell B2, B3, B4, etc, to contain a percentage value based on a formula and some other entries I have made.

It should be simple, but I'm having trouble - how do I set up A2, A3, A4, etc, to highlight into different colours based on Column B's data/percentage falling into a certain range?

ie: - if B2 is between 0% - 25%, then highlight A2 green
- if B2 is between 26% - 50%, then highlight A2 orange
- if B2 is between 51% - 100%, then highlight A2 red

View 2 Replies View Related

Auto Increment Specific Cell Value Based On Different But Related Cell Value

Nov 20, 2011

In my excel workbook, I have a customer table and invoice sheet among many others.

As part of my system, there is functionality to grant new customers with a discount on the first purchase. Within my customer table, the last two columns are "Number of Purchases" and "Customer Type" (either single/multiple depending on no. of purchases), which are then used to determine whether the discount is valid or not on the invoice.

Once an invoice has been created, archived and refreshed with the customer selected (via a Customer ID), I would like some code to auto increment the number of purchases on the Customer table for that specific customer to +1.

For example, customer called Bob (Bob-1);
Number of purchases = 1
Customer Type = Single
Discount = Yes

Invoice then created for Bob (using Bob-1 as the unique value), sent off and refreshed. New figures should be:

Number of purchases = 2
Customer Type = Multiple (can be achieved by using IF statement on No. of purchases)
Discount = No

View 1 Replies View Related

Highlight A Row Based On A Cell

May 15, 2007

I have a macro that already works well but I need to make a change to it and I can't figure out how to do it.

I need so when the macro is run it will prompt the user for a date. After they enter the date it will highlight cells A:K on each row that data appers.

A little background for this. It is a schedule for a call centre which can show two to three weeks of schedules per agent. We rerun the macro each day to update break times and I would like it so it will highlight todays line.

View 14 Replies View Related

How Do I Highlight A Cell Based On Conditions Of Another?

Aug 5, 2009

I want to highlight A1 red if C1 is greater than 55. Is this possible?

View 3 Replies View Related

Highlight Entire Row Based On Cell Value

Aug 13, 2009

From what I understand this is a simple process but since I am new to programming and I am in need of help. I am trying to write into one of my macros that as it is searching in the sheet if it finds CRL in column C and if it finds a value between -1 and 100,000 in column K, then it will highlight the entire row green.What can I do to add this into my macro?

View 14 Replies View Related

How To Highlight Data Based On Another Cell In Same Row

Jan 27, 2014

How can I highlight data based on another cell in the same row?

Ex. I only want to Select data in Column C only if Column B = Rm2

A B C D
1 Bob Rm1 x 0
2 Jack Rm1 x 0
3 Dean Rm2 n 0
4 John Rm2 n 0
5 Barb Rm3 x 0

View 3 Replies View Related

Highlight Cell Based On 2 OR Conditions

May 15, 2008

I am seeking assistance with code for column H to be highlighted when I have a value of "Pending" or "Work In Progress" is present in column E?

View 3 Replies View Related

Conditional Format - Highlight Cell Based On The Value Of Another?

Jul 24, 2013

Looking to use conditional formatting to highlight a cell based on the value of another.

I.E. Highlight Cell B2 if Cell A3 is 4 or greater.

View 2 Replies View Related

Highlight Row Certain Color Based On Character From Cell?

May 11, 2013

INVENTORY-TRACKER.xlsx

I have a attached an inventory spreadsheet that I use at work. The only active column that gets data entered into it, is column E "Qty (Pcs)". I enter quantities of inventory in this column.

In column B is the part numbers for product. The letters at the end of the part numbers are associated with certain colors that you can see in the small chart to the right of the report. H=Yellow, M=Blue, S=Green, V=Orange and P=Purple.

What I am trying to achieve is when I type a value in the Qty (Pcs) row. I would love for the entire row that contains data to highlight in the respective color based on what letter is at the end of the part number in column B.

Example - I type 100 in E2 and the entire row of data turns Orange because the V at the end of 13001 is associated with Orange.

View 3 Replies View Related

How To Make Row Highlight Based On Given Number In Cell

Nov 10, 2011

How do I make a row highlight based on a given number in a cell...

For example my spreadsheet has a balance column...when the balance shows 0.00 for that line i would like it to hightlight gray

View 1 Replies View Related

Macro To Highlight A Cell Based On Other Cells Value

Aug 31, 2012

I need a macro to highlight a cell based on other cells.

For example:-

1. I wants to highlight A3 in red if all the cells from I3 to Y3 are empty.
2. I wants to highlight A3 in yellow if I3 is filled and J3 is empty
3. I wants to highlight A3 in green if if I3 is filled and J3 is also filled.

Actually I am having a grid which shows all the components of watch like KIt, case, dial , strap,hands.

The A row is purchase order no and then I3 and J3 belongs to KIt means if a po is not then I3 and J3 are empty so A3 is high Lighted in REd and if a po is placed then we put supplier name in I3 and it changes the color to yellow and when a po is confirmed we put confirmation date in J3 so A3 turns to green.

So in this way we can see if any Po is not yet placed or not yet confirmed based on cell color.

View 9 Replies View Related

Highlight Part Of Cell Based On Input

Oct 5, 2006

I want to track winning football teams by highlighting the victor. So lets say I have a cell that contains

Raiders @ Niners

and another cell containing "home" or "away" indicating the winner.

Based on the home/away cell, I want to either highlight Niners/Raiders.

View 4 Replies View Related

Conditional Format To Highlight Cell Based On Corresponding Date

Jul 24, 2013

Not very good at this but I have the basic sheet attached. All I want is a way to highlight the first cell when the date is within 30 days of the "Due date".

Calibration Record-example.xls

View 4 Replies View Related

Highlight Cells Based On Cell Reference On Another Worksheet

May 27, 2014

I am trying to find a way to automatically highlight all the cells specified by the cell references in a column on another worksheet (which will constantly have new values added).

On the attached sample, the 'Data Before' tab shows the base data before any highlighting. As cell references are added to the 'References' tab in 'column A' I want the respective cell to be highlighted on the 'Data Before' tab resulting in the 'Data After' tab and each time a new cell reference is added to the 'References' tab, the respective cell is then highlighted on the 'Data Before' tab.

I would like to have control over the highlight colour so that a different highlight colour can be specified for each date change, i.e. all cell references that are shown on the same date are the same colour but where the date changes a different highlight colour can be specified.

Highlight by Cell Reference.xlsx‎

View 9 Replies View Related

Conditional Formatting - Highlight Row Based On Cell Criteria

May 19, 2013

I need a macro that will highlight a row based on a cell criteria. I have used conditional formatting but there is a lot to format and has dramatically slowed the sheet down. However, I know nothing about macros/vbas.

E.g. If it states JI sent then I want the whole row to be highlighted light green.

App form needed = peach
Waiting list = light blue
Cancelled = red font strikethrough
DNA = purple font strikethrough.

Also - it could well be that in the row it has App form received, JI Sent and DNA all in 1 go. So ideally I would want that row to be highlighted light green with purple font strikethrough.

Booking Status
JI Status
Date JI Sent
Attendance
Cancellation date
Chargable / non chargable Cancellations
Chargeable / non chargeable DNA
Date taken
Time taken
Event Title
Start Date
Time

App form received
JI Sent

[Code] ......

View 3 Replies View Related

Highlight Cell Based On Two Randomly Generated Number

Jan 19, 2014

I am trying to highlight a cell based on two randomly generated number, one is the column and the other is the row. Based on those values I want to change the color of a cell in a range of data. The formula I am using does not work like I intended. It only changes the cell once I enter a value in the cell not until. =OFFSET(A1,B27,B26). B26 and B27 are the cells housing the random numbers and A1 is the base reference.

View 1 Replies View Related

Highlight Or Change The Color Of A Cell Based On The Date

May 10, 2007

I looked around at some date functions and could not find one to work.

I have a sheet that has 365 days. When I load the sheet I want to cell for today to be highlighted in some way..... color or just active.

If date = 05-10-2007 then
BackgroundColor = 17
else
BackgroundColor = 9
end if

View 9 Replies View Related

Highlight An Entire Column Based On A Cell Date.

Jun 9, 2009

I want to highlight an entire column based on whether a cell in that column is equal to today's date.

I know how to write a loop that cycles through all of the columns until it finds today's date and then modify the column's properties, I was wondering if there was an easier way to do it. Also, I want the highlighting to be temporary meaning it should not save.

View 9 Replies View Related

Conditional Formating: Highlight Cells Based On Text Of Another Cell

Aug 28, 2009

I have created a drop down box that allows me to choose multiple different Text Options. Example: Cell B4 has dropdown that lets me choose the Text Options, "House", "Car" and "Truck".

Next, I have 5 or so other columns underneath with their own text. What I want to do is have different cells highlight themselves depending on what is in Cell B4.

Example, if "House" is selected in B4, I want cells B7 and B9 to highlight. If "Car" is selected, I want cells B7, B8, and B10 to highlight. If "Truck" is highlighted, I want cells B9-B11 to highlight. Is this possible to do? I've tried using If/Then statements, but those don't seem to work for this type of thing.

View 3 Replies View Related

VBA Code To Find Row Number Based On Data Via Input Box And Highlight Cell?

Jun 21, 2014

I want to enter a unique ID into an input box which will tell which row that id is available and then it will again ask me which column the cell needs to be highlighted. Once i enter the data, it will then ask me what is the change in data (again via input box). i can then enter the change data and then it stops.

View 1 Replies View Related

Excel 2010 :: Highlight Entire Record Based On Value Of Single Cell?

Apr 10, 2013

MS Excel 2010, WinsXP

how to highlight an entire record based on the value of a single cell?

I would like to highlight all records grey where cells in a column = "closed".

View 4 Replies View Related

Auto Name Tab Based On Cell

Oct 5, 2009

I would like the tab at the bottom of the sheet to Automactially name = to cell C5
So if Cell C5 = "Ryan"

The tab at the bottom of the sheet will be named "Ryan"

View 9 Replies View Related

Auto Grouping Based On Cell Value?

Apr 1, 2014

I'm building a sales tracking spreadsheet and need to find a way to auto group certain rows based on their cell value. In my tracker I'd like to group by company name and be able to collapse it to look at the details.

Here's an example of my starting point and how I'd like the data to look like in the end.

Starting State:
Company Name contact name sales stage Forcast amount
----------------------------------------------------------------------------------------------
Company A david brown contracts 10,000
Company A John Smith Won 20,000
Company A D'Arcy Davis Canceled 10,000
Company B
Company B

Desired State:
Starting State:
Company Name contact name sales stage Forcast amount
----------------------------------------------------------------------------------------------
+Company A 30,000
+Company B

View 1 Replies View Related

Auto-filter Based On Cell Value

Feb 18, 2014

I have two problems:

1) Eliminating doubles when ranking
2) Auto-filtering based on cell values

The first problem is an issue with my formula I believe (I am using a RANK + COUNTIF-1) formula (Shown in tab #2, column L of the attached document)

The second problem will need a macro, but I am not very strong with VBA. In the attached document, I am looking to be able to filter the table in tab one based on the selections I have included at the top. I was able to filter the table based on # of IDs displayed using a formula. The second filter is looking to only show the values in the table that satisfy the condition that column E must match the filter chosen (cell C3).

For example, of the filter chosen in cell C3 is "Yes", I would like the table to rank and display only those rows with a "Yes" in column E.

Attached: Excel_Help1.xlsx

View 2 Replies View Related

Auto Email Via Outlook Based On Cell Value

May 4, 2013

I need to send an email when value of timer in column F exceeds 72 hrs. E-mail address of recipient is in column C and 2 fixed addresses are to be put in C.C.

basic outline would be

name(A) work(B) E-Mail(C) Work Started (D) Work Finished(E) Time Elapsed for Work from Start (F)

Can this emails be sent to repeat also after 24 hrs if the timer in F is not stopped (i.e till no entry is put into Column E)?

View 2 Replies View Related

Auto Hide Columns Based On Cell Value

Mar 12, 2012

I got an excel, with a "validation list" in a certain cell.

Users can select value1, value2 or value3. based on this value, some columns will have to unhide (standard= hidden)
(only for value2 this is the case).

I used the worksheet_change event to determin the value, but so far I'm only getting it to hide...

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
If C24 = "value2" Then
Columns("H:O").Hidden = False
Else
Columns("H:O").Hidden = True
End If
End Sub

View 5 Replies View Related

Auto Hide Rows Based On Cell Value In Same Row

Apr 1, 2013

I am creating a copy of a spreadsheet (table format) in a separate workbook using formulas that will update the copy as the original updates. I would like to auto hide the rows that have the value "Returned" in column G. I have columns A - G , rows 2 - 2000. The value "Returned" is the result of a simple = formula. Is there some way to accomplish this?

View 4 Replies View Related

Auto Sort- Row Refernce Based On Cell

Feb 18, 2009

I am typing a number into Cell B4 (ex. zza4582) this number is a serial number that will be in many differnt cells in column "A" on a different sheet "Template Paste". On each row with that serial number I need the information from "A-I" to be copied in the main sheet starting on row 10 and continuing on from row to row depending on how many times the serial number is found.

View 10 Replies View Related







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