# Conditional Formatting Of A Cell Depending On Another Cell

Jul 9, 2014

I want to conditionally format cells K8, L8 and M8 so that when cell C3 contains a 3 it causes the previously mentioned three cells to fill black.

I cannot seem to work out how to do this using the options available under conditional formatting. Is there another way?

## Excel 2010 :: Conditional Formatting Of Cell Depending On Value Of Another Cell?

May 9, 2013

I'm using Excel 2010 and I would like to format a cell (say, the font of that cell turns RED) if the value of another cell meets a certain criteria.

## Conditional Formatting - Highlight Color Of Text In Particular Cell Depending On Value

Dec 22, 2013

I would like to know the formula to highlight the color of text in particular cell if the value of the particular cell ( value is text ) is so and so.

For Ex: If the J6 is "Vacation" then the J1 text should be in red color.

## Conditional Formatting Depending On Two Other Cells?

Jan 27, 2014

On the attached spreadsheet, is there a way of highlighting a cell because it is a greater number than two other cells?

Can cell C3 be highlighted green because the number is greater than G3 and K3?

Can cell E3 be highlighted green because the number is greater than A3 and I3?

Can cell K4 be highlighted green because the number is greater than C4 and G4?

## Conditional Formatting: Format 3 Columns Depending On Certain Value From Another Column

Mar 26, 2009

I want to format 3 columns in excel depending on certain value from another column.
By example: I have the columns A B C completed with some text. On the column D it will be the numbers 0 or 1. If the number is 0 the background color from A,B,C columns shall be Green, if the number is 1 the color shall be red.

I have tried in conditional formatting with the formula =\$D\$1=0 but the color of the columns are changing only depending on the value from cell D1. I don't know what is the correct formula. For column A1 I want to check the value from D1, A2 - D2, A3 - D3,...,An - Dn.

## Formula / Conditional Format To Award Score From 0 To 4 Depending On Cell Value

Jul 24, 2014

I want to create a system based on the value of a cell appearing as a grade in the adjacent cell. The cell could contain any value from -10 to +10.

the criteria would be

value greater than +2 = 3
value between 0 and +2 = 2
value between -2 and zero =1
value below -2 =0

I can get a formula to work for a single instance but not multiple conditions.

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

## Conditional Formatting - Highlight Cell If Exists In Any Cell In Range Of Above Row

Apr 14, 2013

This is a conditional formatting problem I have not been able to resolve:

I have a range, say A1:N30

Each cell contains a text/number combination.

I would like to highlight each cell on a specific row if the vale exists within the row above - the issue is that the cell values are not in the same columns.

I have attached a sample workbook with the desired output.

Conditional formatting.xlsx

## 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)

KO_04.01.14.xlsx

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

Possible???

## Conditional Formatting To Flag The Row Green If Cell E2 Has A Y Or A N In The Cell...

Sep 1, 2009

I've set a conditional format to flag the row green if cell e2 has a Y or a N in the cell.

Currently i have the following conditional format formula is as

=IF(\$E\$2="y",TRUE,FALSE) this is set to change row to green
=IF(\$E\$2="n",TRUE,FALSE) this is set to change row to red

My Questions =

What i want to do is copy this formula through the 500 or so rows and have the formula adust to
=IF(\$E\$3="y",TRUE,FALSE) For row 3
=IF(\$E\$4="y",TRUE,FALSE) for row 4
=IF(\$E\$5="y",TRUE,FALSE) for row 5

Ect.

I've tried using the formate painter but all it does is set all row to conditionally format dependant on what is in Cell E2. Thoughts on how to copy this formula is conditional format so i don't have to manually adjust it line by line. Doing this 500 times over would be a pain.

## Conditional Formatting (the Cell In Row 6:6 Of The Corresponding Cell In Between Are Not Empty)

Sep 2, 2009

some cells in column C:C and row 6:6 contains information [are not empty]

Now I'd like to place a border on all cells in between, but only if both, the cell in C:C and the cell in row 6:6 of the corresponding cell in between are not empty.

## Conditional Formatting If Current Cell Contains X And Another Cell Contains Y

Jun 3, 2014

A question regarding conditional formatting. Here is my current situation.

A
B

1
Name
DOB

2
John
01/01/01

3
Jack
02/01/01

4
John
01/01/01

I want it so that when there are 2 of the same names with the same DOB that all of those fields in A will be highlighted.

## Validation/Conditional Formatting Cell From Cell

May 16, 2008

Excel 2003 Scenario:

Column H contains text data as follows down the rows: BIKE/CAR/TRUCK.

Column N contains text data that would be entered free text by user down the rows; however, if the data entered in column N is not contained in column H it would warn the data is not contained in column H. Example: BOAT is not found in column H. Note; it could contain all text in column H for that row or just one word in column H for that row.

The goal is to recognize the text entered in column N is not contained in column H, warn and change the color of the text in column N to red.

I attempted to use Data/Validation, and Conditional Formatting; none seem to have a contain function.

Is there a formula or VBA I may use or any thoughts?

## 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?

## Conditional Formatting From Another Cell

Jan 8, 2009

A1 is not in any pattern colour. But if A1 is changed into, say, Red, B1 will be equils to D5+F5. Otherwise if A1 is changed into Blue, B1 will be equils to D6+F6. Can it been done by Excel 2003?

## Conditional Formatting In Cell

Jul 7, 2007

I have a conditional format in Cell J3 that has 2 conditions as follows:
Condition 1: Cell Value, Equal to, ="NO", and then the format will color the cell RED.
Condition 2: Cell Value, Equal to, ="YES", and then the format will color the cell GREEN.

I want Condition 3 to turn the cell J3 YELLOW if there is ANYTHING at all or anything above "0" typed into Cell D3.

## Conditional Formatting - Hide Value From Cell Until It Changes

Apr 12, 2014

I have a formula as follows:- B20 is the cell I wish to format. The formular is =B18-400. My problem is I wish to hide the -400 from the cell until it changes.

## Conditional Formatting Referencing A Second Cell?

May 22, 2014

If the value in column AE falls below 100 it needs to turn yellow. If the value drops below 50 it needs to turn red.

But if the figure in column AB is 0 then i dont want it to do anything at all.

## Conditional Formatting - Highlighting The Value In Particular Cell Red?

May 29, 2014

how to highlight a particular cell red if the value in one cell is less than or equal to the value in another cell. For instance, How do I make it so that the "Hours to go" cell turns red if the value in the "Actual Last Completion" value is less than or equal to the value of "Last Completed" cell?

## Conditional Formatting Using Cell Reference?

Jun 3, 2014

i want to calculate percentage between A and B and highlight top 10 values in B.

as of now i am calculating % in C and applied conditional formatting in C. filtering C based on color i am formatting B manually.

is there any option to avoid this manual work.

Total countAlarm reported%
562545%
783545%
322578%

## Conditional Formatting On Cell Based On Value

Jul 29, 2014

In Excel, I want to do conditional formatting on a cell based on the value of another cell. For example: in cell A1, I have text. I want this cell to have a grey background if the value of cell B1 is less than or equal to 1/31/14 and to have no fill (default) if it is greater than that date.

## Conditional Formatting - Cell Not Being Highlighted

Aug 25, 2014

In the attached, I want cells to be highlighted red if they're NOT EQUAL to 0. Why is this conditional formatting not working (i.e. the cell is being highlighted)?

Conditional Formatting Example.xlsx

## Conditional Formatting Based On A Value In A Different Cell?

Apr 9, 2014

I am working in a table where I would like the whole row to highlight based on the value in one of the cells. These rows of data will be updated regularly, so the formatting has to change with the data.

## Conditional Formatting When Cell Does Not Equal Another?

Aug 21, 2014

This seems way too simple to do yet I can't get it right. It will highlight some that are different and not highlight others that are different. I need to compare column A to O and highlight differences, B to P and highlight difference, and so on.

## Conditional Formatting If Cell Contains Comments

Oct 3, 2008

Is it possible to use conditional formatting on a cell if it contains comments.

## Conditional Formatting To Color Cell

May 19, 2009

I am using the following formula on a conditional formatting to color cell A1 based on cell N5 date =\$N5=TODAY()-2

The problem is that I need this formula to consider only weekdays, how can apply formula weekdays to my formula?

## Conditional Formatting With Empty Cell

Jul 8, 2009

I want to use conditional formatting on a column ('A') to highlight cells that do not have a match with any cells in a specific range.

So I've made a range called 'AcceptedData', which contains a couple of cells with text.
Also included a blank cell in the range, since I do not want blank cells to be highlighted.

Then I used this conditional format forumla on column A.

=COUNTIF(AcceptedData;A1)=0

But it doesn't seem to work. The blank cells get highlighted.

## Conditional Formatting Only Top Line Of Cell

Feb 1, 2010

I have a worksheet with conditional formatting applied. My formula works to change the cell color, font color, and strike-through the font if a "yes" answer is indicated. It all works well EXCEPT that the font color and strike-through ONLY apply to the top line on my cell.

Each cell has a title line, and a few paragraphs in it, with separations between the title line and the paragraphs. I kind of like having the title line a different font, but when it's time to strikethrough I want ALL of the text struck through.

## Conditional Formatting Of A Row Based On A Value In A Cell Of That Row

Feb 17, 2010

I want to create a conditional formatting based on a cell in a row. If the value of that cell is greater than or equal to \$20 the entire row would be highlighted with a color.

the main thing is that the cells in the rows have if formulas that supple the data for the cells. The cells will be blank if nothing is to be displayed but they will still contain the formula.