Conditional Formating (cell Based On The Value Of Another Cell Whish Is Linked To Another Sheet)

Oct 24, 2007

I am trying to create conditional formating of a cell based on the value of another cell whish is linked to another sheet. I an using the "The formula is =$AA$30=1" where the cell AA30 is the cell linked to the other sheet. the problem is I have to do thiss for approx 200 cells ie =$AA$30=1, =$AB$30=1, =$AA$31=1, =$AB$31=1 --- =$AZ$42=1. Do I have to enter the formulea for each cell or is there a way to automate this?

View 2 Replies


Conditional Formating Based A Value Entered Into The First Cell Of A Row

Jan 23, 2010

Is it possible to do a conditional formating based on a value being entered into the first cell of a row?

Basically when a date is entered into a cell in column A, I want the cells in that same row (A-J) to have a border, even if B-J do not have any value entered into them.

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

More Than 3 Conditional Formating Per Cell

Oct 31, 2008

I have a large X-Y-axis table with about 200 entries in it. There are 6 different entries possible. I now want to give each possible entry in this table a color for making it easier to read.

I could write a formula in conditional formating, so that it works for 3 colors. The problem is now that i can make this only for 3 different colors in conditional formating of excel. Is there a possibility for making this for 6 colors?

View 2 Replies View Related

Conditional Formating: Return NA() To Cell

Aug 28, 2007

Is it possible to return NA() to cell A10 if A10>A9, without adding a 3rd cell ??

View 9 Replies View Related

Cancel Conditional Formating If Cell Not Empty

Aug 11, 2009

I am trying to have conditional formatting of cells apply only if another cell is blank in 2007. A3 has a formatting of =MOD(ROW(),2)=1, then =AND (A3<>"",A3+15<=$G$1) to change the color based on date and finally =AND(A3<>"",A3+30<=$G$1) to again change the color again by date. What I would like to do is for the cells in columb A to change only if corresponding columb B cell is empty, without using macros if possible.

View 2 Replies View Related

Conditional Formating: Color The Cell If Value Is Text= Sat Or Sun

Jan 17, 2010

I need the formula that will color the cell if value is Text= Sat or Sun

View 2 Replies View Related

Highlight Current Cell With Or Without Conditional Formating

May 4, 2006

I am now wanting to do if the the cell has an active conditional format also highlight that cell. Currently if the cell has an active conditional format nothing happens

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static rngPrev As Range, PrevColor As Integer
Dim TempColor As Integer
TempColor = Target.Cells(1, 1).Interior.ColorIndex
If Not rngPrev Is Nothing Then rngPrev.Interior.ColorIndex = PrevColor
PrevColor = TempColor
With Target.Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
Set rngPrev = Target
End Sub

View 8 Replies View Related

Conditional Formating :: Place System Date In Cell

Mar 5, 2008

how I could have a range of B15-F15 to place Today's System-date in the Cell: A1, anytime anything is entered in that range?

View 9 Replies View Related

Conditional Formating: Highlight Cells Based On Multiple Stipulations

Sep 14, 2009

I'm trying to get it so that a cell becomes automatically highlighted if 2 other cells conditions are met. For example, I want cell A5 to become highlighted if BOTH cell B1=Loan 1 AND cell B5=Yes. Here is a mockup of what I'm talking about incase it makes it easier to understand. I'm using Excel 2007.

View 3 Replies View Related

Conditional Copy Row To Another Sheet Based On Cell Values?

Mar 17, 2014

This is also in sheet1 module ( It cuts the respected row and pastes in sheet2 when date/time is populated in column 14 by double clicking).


View 3 Replies View Related

Auto Copy In To Cell On A Linked Sheet

Feb 2, 2010

I am wondering if there is a formula/macro/VBA that will find the last date entered in a column and fill that date in to a cell on a linked sheet.


sheet ONE has columns C through S. (each customer has its own sheet)
On this sheet, in column H the date of the last payment made is entered. This date of course changes as payments are made, so the row would change as well.

sheet TWO has columns C through O. (all customers on this one sheet)
The rows on this sheet remain the same for each individual customer.
I would like the last date entered on sheet ONE column H to be auto copied to sheet TWO column O.

Is there a way to have the last date entered on sheet ONE auto copy to Sheet TWO?

View 9 Replies View Related

Find And Replace :: Cell Moving Down In Linked Sheet?

Jan 26, 2010

I have a spreadsheet which is linked to other spreadsheets. When I use "find and replace" on this spreadsheet, it causes one of my linked cells to move down one row. Why does it do this? This particular cell has nothing to do with the "find and replace" option.

I have no idea how to stop this from moving this cell down.

View 9 Replies View Related

Disable User Access To Master Sheet Through Doubleclicking Locked Linked Cell

Feb 23, 2010

I have a master spreadsheet that houses most of the information that remains in my control, and several other user spreadsheets that update cells from that master through links.

I am having some problems lately with users doubleclicking the locked linked cells in their workbooks, and excel then wanting to open and give the user access to my master spreadsheet. Is there a way to disable this feature? I would like it to not even acknowledge the action if that's even possible because it confuses them as to why they are getting a prompt to open another document.

View 5 Replies View Related

Conditional Formatting - Change Cell Color Based On Date In Another Cell

Oct 9, 2013

I have two columns. In column B is the date of "last check". I column A is the date of "next check". I would like to have cell A2 in yellow color 334 days after the date entered in cell A3 and than in red color 365 days after the date entered in cell A3. Same thing for cell B2 related to date entered in cell B3. Yellow color in cells announces that check will expire within 30 days and red color that check has been expired.

View 1 Replies View Related

Conditional Formatting Blank Cell Based On Another Cell Date

Apr 1, 2014

I am trying to alert our purchasing mgr when order dates are approaching or not meeting our project deadline.

As of now i have the following rulesif order date is due today or past due - redif order date it greater than project date - redif order date is due within 2wks - yellow

Now all I need is a rule where there is an order without a due date but the project deadline is within 2wks (yellow) and past due or due today (red)


View 3 Replies View Related

Conditional Formatting Based On Another Cell Conditional Format

Mar 20, 2013

Is it possible to change the format of cell AI3 based on the format of cell C3 and D3? I have C3 and D3 set to turn red based on what is in cell C2 and D2. I would like the following done:

If AI3=C3 & C3 is red, format AI3 blue
If AI3=D3 & D3 is red, format AI3 blue
Otherwise, leave AI3 unformatted.


View 3 Replies View Related

Conditional Format Cell Based On Data From Another Cell

Nov 11, 2012

Can I conditions format a cell based on data from another cell?

View 8 Replies View Related

Formating A Cell And Cell Font Color

Jun 5, 2006

i am use exl2000 and i made a workbook with password protection. 2 sheets are in this workbook. one sheet is password protected and second is not protected. i want to change the cell color and font color (Cell is locked) in protected sheet. i want to give only content protection and user cannot delete the text but he will change the color of text.

View 6 Replies View Related

Conditional Cell Based On Actions Of Another Cell

Oct 3, 2008

Is it possible to have a conditional cell based on the actions of another cell in a second database sheet.

For example: A single excel file contains two database sheets. If any characters are entered into cell A1 of sheet 2, then cell A1 of sheet 1 turns grey.

View 4 Replies View Related

Conditional Locking Of Cell Based On Another Cell

Oct 7, 2008

This is for Excel 2007. I simply want to lock cell H20 and make it's value equal to zero if anything other than 0 is entered into H19. And vice versa (make H19 equal to 0 and lock it if anything greater than 0 is entered into H20). So only one cell can hold a value not equal to zero at a time, and the one that is zero needs to be locked. Here's what I have so far. It locks H20 based on H19 being > 0, but doesn't do the vice versa part. And it also doesn't make H20 = 0 when it locks it.

View 4 Replies View Related

Conditional Formatting Based On Cell & Corresponding Cell

Jan 12, 2008

1. A1 needs to turn red if a value greater than $2,000 is inserted.
2. A1 will turn back to white if either "John Doe" or "Jane Doe" is inserted in B1.
3. If no value is inserted in A1, A1 needs to remain white.
4. I'll need to do the same for A2-B2, and so on.

That's it. I tried this in C1: =IF(AND(A1>2000,B1="JANE DOE"),1,IF(AND(A1>2000,B1="JOHN DOE"),1,0)).

I then used Conditional Formatting in A1 to point to C1 and turn the red in A1 off or on based on the result. Hey, it worked! Problem is, A1 needs to stay white until a value is entered, and no value entered returns 0 (red), which oddly enough is exactly what I'm telling it to do. Surprise! How do I get A1 to default to white until a value is entered in A1?

View 5 Replies View Related

Excel 2003 :: Conditional Format - Highlight Cell In Sheet 2 If Duplicated From Sheet 1

Mar 25, 2014

I have two Sheets, first is Service Data, the second is Log Sheet. In the Service Data sheet I have a column of serial numbers in column A. I also have a column of serial numbers in the Log Sheet, column A.

I'm looking for a conditional format whereas I enter numbers into column A on the Log sheet it will auto highlight the cell if I duplicate a serial number from row A in the Service Data sheet. I would like it to highlight the Duplicated number on the Log sheet. I know new versions of excel make it easier to do this but unfortunately I have Excel 2003.

View 3 Replies View Related

Excel 2007 :: Checkbox Linked Within Cell Value Will Show Up When Cell Value Searched

Jul 1, 2014

I have this worksheet with 2 buttons and 2 textboxes.the first button is named search literally to search the items inputted in the textboxes and the second button is clear which clear all the inputted items in the textboxes and the search field. I manage to code those things however I have a main problem. How am I suppose to linked a checkbox with those items?

For example I searched this particular item so the checkbox corresponding to that item must show up in the left most column of it. and if I searched multiple items those checkboxes must show up too. I am having a hard time coding and trying since I am new in vba. I also attached a sample worksheet. I am using excel 2007.


View 1 Replies View Related

Returning Cell Value From Sheet 1 Based On Cell Reference From Sheet 2

Oct 29, 2013

In Sheet2 I have a list of cell addresses showing values such as D5, D32, D59, D221, D869 stored in cells AB7:AB16. In Sheet1 the "D" column holds dates. I want to return the corresponding date for each D# cell into Sheet2 in column AC7:AC16. I'm unaware of the proper syntax for this. I though it would look something like:


however that doesn't work.

View 2 Replies View Related

MOD+ROW Conditional Formating

May 18, 2009

I have an excel document that has one columb (I) of cells that changes color depending on a specific date (columb h) . The cells that have conditional formating to change the row color based on where it is ( =MOD(ROW(),2)=1), stays blank and the proper color until columb A is filled in. The others show up red. How would I code/format the lines that aren't included in the conditional formating to always show white when no value is entered in columb a.

View 9 Replies View Related

Conditional Formating A Row

Jul 20, 2007

how to use the conditional format tool, but now the company i designed the spreadsheet for, wants me to implement a change. I'm attacking a copy of the spreadsheet so you can see the problem more easily. Now what I've been asked todo is the following.

1. When the stock quantity (Column H) goes below the re-order level (Column K), they want the entire row to change font colour from blue to red. Now I know how i can change the colour of one cell, like ive done in the example, but I'm not sure how to change the entire row colour. If this can be done with conditioning formating then great, but if not then i'm stuck, and relying on your generosity in helping me out.

View 2 Replies View Related

Formating Cell

Mar 7, 2007

I need to replace a "." with a "," to stay in the right format, by using VBA.

if i make a macro to do it, it will work for almost all cells but for a few it doens't work!
Then, if i select the cell with mouse and replace "." with a "," it works normaly.

My question is why it doesn't work for a few fields if all the data have the same format?

View 11 Replies View Related

Formula To Return Value In A Cell Relative To Another Linked Cell?

May 2, 2014

The problem I am trying to solve is to have a cell return a cell value based on another linked cell. The cells I want to link are in separate tabs or could be another workbook.

For example if cell A5 in sheet2 is linked to A20 in sheet1...A5 has formula(=Sheet1!A20). I want the next cell B5 to look at A5 and return the value of cell Sheet1!D18.

So in essence I want the second cell to look at the first cell and return a value that is 3 columns over and 2 rows up.

View 4 Replies View Related

Conditional Formating With Even Numbers

May 8, 2009

i have 2 columns the first is the transaction number and second column is the description

i want to make that all even transaction number will highlight the whole row... how do i make that with conditional formatting? or are there other alternatives?

View 8 Replies View Related

Copyrights 2005-15, All rights reserved