# Conditional Formatting: Change The Cell Next To It A Color

Oct 25, 2007

I would like to be able to put a value into a cell. By doing this I would like another cell next to it to turn a color. With that said, is it also possible to format a cell with several possible scenarios in one formula to be able to change the cell next to it a color?? Example is this lets say Cell B1 could have the letters, A B C D or E entered. So that the Cell A1 turns say the color Red.

## Conditional Formatting :: Change Font Color Of Cell

Mar 5, 2007

Cell B157 is changed by checkbox 1= TRUE, 0 = FALSE
Cell H1 and Cell H2 are percentages changed by the user.

Range(AI8:AQ8,AI12:AQ12,AI16:AQ16,AI20:AQ20, etc) each cell in the range contains a formula, and is protected from the user.

I need the contents of each cell in the range to change font color (independent of each other) when the formula of any of the cells within the range changes - to the following

If B157 = 1

Cells < H1 (a percentage changed by user), would turn Red
Cells > H1 but < H2 (a percentage changed by user) would turn Yellow
Cells > H2 would be Green

If B157 = 0

Cells < H1 (a percentage changed by user), would turn Green
Cells > H1 but < H2 (a percentage changed by user) would turn Yellow
Cells > H2 would be Red

I need it to fire whenever the value of one of the cells in the range changes.

I have tried If statements, Select Case, and a combination of both but just can't get it!

## Conditional Formatting - Cell To Change Color When Apply Specific Value

Dec 4, 2012

I know how to set a conditional for a cell to change a color when i apply a specific value, but how about if i want to set E2 cell to change to green when i place a 'X' on F2?

Pretty much I want 2 columns that say Yes and the Other No. When i place a X on Yes that other cell turns green, if i place a X on No that other cell turns red.

## Get Conditional Formatting To Change The Cell Color Based On A Few Conditions?

Jul 19, 2013

I'm trying to get conditional formatting to change the cell color based on a few conditions.

I want the cells in column D to turn red if;

- The number in column B has a match in column A

- And the corresponding cell in column C is not blank

- And the corresponding cell in column D is blank

In the example below, cell D4 should be red

If there's a match (Column B to Column A) and;

- If cell in column C is not blank and cell in column D is not blank, do nothing.

If there's a match (Column B to Column A) and:

- If cell in column C is blank and cell in column D is blank, do nothing.

Here's the formula I attempted but didn't get it to work.

IF(AND(C2"",D2=""),MATCH(B2,\$A\$2:\$A\$15,0),IF((AND(C2"",D"")),"",""))

## Conditional Formatting - Change Value Font Color In Cell Based On Matching Text?

Jun 26, 2013

Via conditional formatting, I am searching to change the color of a specific word in a cell (not the color of everything in the cell, but only that specific word - and the word repeats in the cell). A function such as =isnumber(search("NOK";A1)) colors all the cell values, which I do not want to do. How i can perform this task?

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

## Whole Row Color Change - Conditional Formatting

May 25, 2007

I'm trying to make a tracking sheet of upcoming annual inspections for different pieces of equipment. I've already got a column set up listing the inspection due date. Using three conditional formats, the individual cells change color based on the amount of time until the inspection is due (green normally, yellow at 30 days out, red past due).

What I'd like to do is have the entire row of information change color based on the color of the cell the inpection due date is listed in. For ex. J6 lists the inspection date as 24-Feb-07 and is therefore red, I'd like A6-I6 and K6-P6 to change to red as well. And when the inspection is compleate and I manually change J6 to say 25-May-07, I'd like all of row 6 to change green based on the fact that J6 is already going to.

## Conditional Formatting: Change To The Approriate Color

Feb 4, 2007

I have one cell (M6) wich will have one of the following values:

Pale Yellow
Yellow
Yellow Orange
Orange
Red Orange
Red
Red Violet
Violet
Blue Violet
Blue

This cell is filled in by a formula.

I would like this cells (M6) color, to change to the approriate color.

## Conditional Formatting: Change Another Cells Color

Dec 3, 2009

Is it possibe to change another cells color (Fill) based on what is placed in that cell? Example: A1 =if there is an "x" in A2 highlight A1 Green, but I have information in A1 also. Or if I had a different cell say= if there is an X in A1 Highlight A1 Green ect.. This key is to highlight a cell that I have information in based on a different cell having an X in it. If ther eis no X in the cell I have indicated, nothing needs to happen.

## Conditional Formatting Change The Font Color

May 11, 2006

Using conditional formatting I can change the font color (to blue) of a cell if it meets a certain criteria. Now what I would like is to display a message when the color changes to blue. The cell range is E26 to E40.

## Conditional Formatting - Change ICON SETS Color

May 23, 2014

Is it possible to change color for arrows icons in CF- icon sets? I would really like to have a five arrows pointing in different directions (all in different colors).

Can I do it in conditional formatting or should I go for "Wingdings" fonts and then change font color?

## Conditional Formatting Change The Font Color And Look Blanks

Jul 8, 2008

I have a simple sheet that has columns I-K. My issue is that in column K I am dividing J/I. If both J and I cells have a "0" then I get the #DIV0 error. If both J and I cells are blank then I get the #VALUE! error. I need it so that if the cells in J and I have a zero in them then it places a 0 in K. But if both J and I are blank then it puts something else that I can have Conditional formatting change the font color so column K looks blank. I think the IF formulas I am try to use recognize blank cells as zeros as well.

## Conditional Formatting Conflict: Change The Cells Font Color And Bolding As Long As The Value Is Within That Date Range

Oct 19, 2006

I have two conditions setup in Options>View - Zero Values.", "style="background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;"");' onmouseout='GAL_hidepopup();'>formatting.htm" target="_blank">conditional formatting. The first is setup for alternate row coloring with this formula inside Conditional Formatting:

Formula is = MOD(ROW(),2)

My Second Condition is

Cell Value is between \$P\$10 and \$Q\$10. This sets the font bold and a different color. The two cell values are two dates. I want to change the cells font color and bolding as long as the value is within that date range. It works fine, but for cells that are on the row that is colored the second condition doesn't apply for some reason.

## Conditional Formatting - Cell Color Based On Range Of Cell Color

Aug 9, 2013

Summary of performance of various products against target is as follows,

Product vs Target
Color Code
Result

CH4OH
Green
1.0

[Code] ........

I need the final result automated as follows,

If 2 green of the 4 products, then final result Gree
If 2 Amber of the 4 products, then final result amber
If 2 Red of the 4 products, final result Red

Is there a way to automate this?

## 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 Cell Color

Jun 22, 2006

I am trying to write a VBA code to color cells.

In Column I

I need a formula to change the color of the cell based upon the following criteria

In cell I3, if J3>7 change color to teal, if H3<\$A\$1 color cell red, if J3<7 color cell yellow, if J3="COMPLETE" color cell grey, otherwise do nothing.

## Conditional Formatting - Change Bottom Sheet Number Color If It Exists On Top Sheet

May 25, 2014

First off I have an excel sheet that I have split into two windows. excel sheet.jpg

I am looking for a formula that will change the bottom sheet number a color if it exists on the top sheet.

## Conditional Formatting To Have Cell Shaded Certain Color?

Jan 16, 2014

Is there a way in conditional formatting to have a cell shaded a certain color based on the value of another cell in that same worksheet?

## Conditional Formatting - Fill In Color To Cell?

May 13, 2013

I have 10 rows of 6 numbers, all between 1 & 49, in the range A1:F10. I also have the range A20:AW20, which are all currently blank cells. When I type a number between 1 and 49 inclusive into the range A20:AW20, any number that matches it in the range A1:F1 I want the cell to fill in colour.

## Conditional Formatting :: Color A Cell If It's Divisible By 10

Oct 30, 2009

Is it possible to use conditional formatting to to turn a cell red whenever the value in the cell is divisible by 10 ?

## Conditional Formatting - How To Make Cell Shade A Certain Color

Apr 5, 2012

How do I make my cell shade a certain color? For example, green if >90%, yellow if >70% and red if

## Conditional Formatting Based On Color Or Text Of Another Cell

Jun 14, 2013

1 2 3 4 5 6
1
2 x x x x
3 x x
4 x x
5 x x
6 x x

Assume that is the table i have. In row 1 i need conditional formatting such that if any of the columns contain an x the first row should be color coded. In my above example every column in row 1 will be color coded expect for row 1 column 6 since there are no x's for any any row in column 6.

How can i do this in excel.Also instead of x's if i have manually entered color can we do the same ?

## Change Cell Color W/o Using Conditional Formula

Mar 10, 2009

I want to create a function or vba code for a column IF any text in that column is = to Selfpay turn them all to Red text. I want to do this without using conditional formula.

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

## Excel Conditional Formatting (Color Cell Based On Their Values)

Dec 29, 2013

Here i want to color my cell based on their dates for example : 01-Jan-2014 to 10-Jan-2014.

For the respective date i want to color my bars from G10 to P10.

## Excel 2013 :: Extract Cell Value If It Has Conditional Formatting Color?

Mar 26, 2014

I have been trying to make a macro to automatically calculate the quantity I need to increase or decrease our purchase orders.

example.jpg

As the On Hand quantity decreases I have set conditional formatting to determine how much we should order according to a percentage of the Stocking Level and turns the desired cell yellow. For each row the macro would need to identify which cell in columns L through O is yellow from conditional formatting, use that value and subtract the On Order quantity, then put the result in the Adjust PO Qty (+/-) column so I know how much to decrease the order if negative or increase if positive.

## Conditional Cell Color Change For Multiple Cells

Dec 11, 2008

I'd also like to have it be able to change the 2 cells to the right, in columns (M&N) whenever the conditional value given below are true. I thought I had posted this message yesterday but never saw it show up as a thread.

Private Sub Worksheet_Change(ByVal Target As Range)
Set MyPlage = Range("L1:L800")
For Each Cell In MyPlage

If Cell.Value = "Hold" Then
Cell.Interior.ColorIndex = 3
End If
If Cell.Value = "Complete" Then
Cell.Interior.ColorIndex = 4
End If
If Cell.Value = "Issued" Then
Cell.Interior.ColorIndex = 43
End If
If Cell.Value = "Release" Then
Cell.Interior.ColorIndex = 36................

## Using 'IF' With Conditional Format (change Cell Color Based On The 'P' Or 'F')

Apr 28, 2009

My cell has a 'P' or an 'F' plus some additional text. I'm trying to change cell color based on the 'P' or 'F' but I can't get it to recognize the letters.
Samples of what I've tried:
=IF(LEFT(L23,1)=P)
=IF(MID(L23,1,1)=P)
etc.

I can 'FIND' the 'P' or 'F' but there may be a P or F else where in the cell so the color may come up incorrect. I'm trying to get it to just look at the first character in the cell. Can the 'IF' be used with CFs?

## Excel 2003 :: Conditional Formatting For Currency Symbols And Cell Color

Jun 15, 2011

I am using excel 2003. I need to conditional formatting for the following:

Based on the column A, if it is USD, the next column show \$ and the cell in blue

If it is JPY, the next column show Yuan sign and the cell in green
If it is Euro, the next column show Euro Sign and the cell in yellow.

How to make that happen?

## Conditional Formatting Value Change Of Same Cell

Apr 22, 2013

I have a spreadsheet of stock data open, high, low, close etc., that streams in real time from thompson reuters. i am trying to conditionally format the G column which is the "(HIGH)" price of the day to alert me when the value of that cell changes price. Basically during the first 15 min of trading my software filters down the top performing stocks of the day. During that time i drag and drop the information in the excel program that is linked to the stock quotes program which might give me up to 30 or 40 stocks. The conditional formatting is to alert me after the 15 min mark if the "(HIGH)" value in that column has changed price to a new high. I can control the stream of the data with a button that turns off the data stream so that it only goes live after 15 min.

photo (1).jpg