# Highlighting The Cells Using Conditional Formatting

Aug 19, 2009

Is it possible to highlight a1:h1 if cell a2 contains dark?

i used this code in cell i1-->=MATCH("dark",a2,0)

and i dont know what's next, my friend in the office told me to use conditional formatting.

## Conditional Formatting - Highlighting Specific Cells

Jun 7, 2013

I'm having issues with conditional formatting. I used the INDIRECT formula to highlight specific rows.

For example, column A has the days of the week. I wanted the whole row highlighted if it was a Saturday. I used:

=INDIRECT("a"&Row())="Sat"

What I want to do now is to highlight specific cells (Columns F and G) if column A has Friday in it. I do not want the whole row highlighted if it contains Friday.

## Conditional Formatting For Highlighting Cells With Dropdown Values

Mar 19, 2014

I want to highlight all the cells in a worksheet that have dropdown lists in blue color. Not sure how to do it.

## Conditional Formatting - Highlighting Lowest Value Per Row

Apr 6, 2014

I have made a price comparison table.

It is set out as follows:

B = price , C= supplier, code D = price, E = supplier, code F = Price, H = supplier code, J = Price, K, Supplier code, L = Price, M = supplier code, N = price, O = Supplier code.

Each row is a product, so I am trying to compare each suppliers price (B,D,F,H,J,L,N) per row and highlight the cheapest price.

Whenever I get it to work it looks for the cheapest price in the entire table rather than on a row by row basis.

## 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 - Column And Row Highlighting

Nov 5, 2013

I have a query relating to conditional highlighting - specifically highlighting a cell's column and row based upon whether it contains data or not i.e. if it is blank, it's column and row remain unhighlighted, but when it contains data, it's column and row should become highlighted. I could probably manage this myself but I have a few more specific requirements which I have illustrated with a few screenshots, however I can't see how to make these available to view here!I

## Conditional Formatting - Highlighting New Additions To List

Jan 14, 2013

I am wanting to highlight the ID's on list 2 which don't appear on list 1 and vice versa highlight the ID's on list 1 which don't appear on list 2.

## Conditional Formatting / Offset - Highlighting Range?

Feb 2, 2013

I am using this Formula =Sum(Offset(A1,,,D1)) where I put for example number 4 in D1 and I get the sum starting cell A1 till Cell A4

I want the range to be highlighted as well, but I don't know how to do it.

## Conditional Formatting - Highlighting One Or Two Numbers In A Column?

May 18, 2013

I want to have Excel highlight one or two numbers/cells in one column based on the value in another cell. I am attempting to do this using Conditional Formatting.

For example, if X1 is BETWEEN A2 and A3, I want to highlight A2 AND A3. I have used various AND and IF functions to achieve this goal.

Also, if X1 is EQUAL to A2, I want A2 to be highlighted. This is easy to do with a simple formula.

But my problem is this: if X1 is equal to A2, I want ONLY A2 highlighted. If X1 is between A2 and A3, I want BOTH A2 and A3 highlighted. I cannot figure out how to achieve both. For example, when X1 = A3, A2 AND A3 are being highlighted, instead of just A3. I would prefer to do this without a macro, if possible. Can this be done?

Example formulas I have tried which easily achieve the highlighting of two cells when the value is between them:

Condition 1=IF(AND(\$I\$35>I8,\$I\$35<I7),1," ")+IF(\$I\$35<>I7,1," ")
Condition 2=IF(AND(\$I\$35<I6,\$I\$35>I8),1," ")+IF(\$I\$35<>I7,1," ")

It appears that the +IF, etc. functions are not doing anything.

This is more complicated by the fact that the value of, in the above example, I35 is based on a value from another sheet (I used a function to transfer a value from one sheet to I35 in the other sheet). As data are entered on Sheet1, the value in I35 in Sheet2 changes.

## Conditional Formatting Of Dates - Highlighting Of Columns

Jul 11, 2006

Well I spent some time yesterday trying to figure this one out. It was only last week that I have taught myself how to use VBA in excel. However this looks like a though one.

Simply what i would like to do is highlight a column of a certain date (till a certain row number) based on a list of dates.

eg. Across the top I have a set of dates and on another sheet i have a list of dates.

I understand that there is a VBA code for such conditional formatting but i can't get my head around it.

## Conditional Formatting Highlighting Data That Matches On 2 Different Worksheets?

Jul 17, 2012

I have 2 worksheets. One has locations with numbers, example:

275 Location 1
276 Location 2

I have all my locations on the second sheet, but in 2 different columns, listed with numbers only, example:
271 275
272 300

I have 2 scenarios I need help with.

1st:
If any of the numbers on sheet 1 match the numbers in column 1 on sheet 2, highlight the number on sheet 1 in green If any of the numbers on sheet 1 match the numbers in column 2 on sheet 2, highlight the number on sheet 1 in red

2nd:
If the number on sheet 2 matches any number on sheet 1, highlight green

I want these to apply to all the cells that have numbers (it could apply to all cells I guess as it should ignore it if it doesn't match, I would assume)

## Conditional Formatting In Excel For Each Row Showing Max / Highlighting It And Ignoring Zero

Jun 1, 2014

I have a data with say around 500 rows and want to determine MAX for each row and HIGHLIGHT them, also if data in all cells is zero then it should ignore and highlight none.

I have tried this formula
=B2=(MIN(IF(\$B2:\$E2>0,\$B2:\$E2))).

But this highlights all the zeroes, you can refer attachment for sample..

## Excel 2010 :: Highlighting Data Based On Conditional Formatting

Apr 1, 2014

I'm using Excel 2010 on my Mac. I would like to set up the data as follows:

A
B
C
D
E
F

NAME
DATA X
DATA Y
DATA Z
DATA XX
DATA YY

NAME
90%
88.2
410
88.4%
97.8

[Code] ........

Now what I would like to do is have the data in each column highlighted a certain color based on specific ranges. For example in Column B I want anything from 92% - 100% highlighted blue. I would like 83% - 91.9% highlighted purple, and anything under 83% highlighted red. Do I need to have a conditional format entered in each cell? Can I set up a conditional format for the whole column? Once I can figure the formatting in my example the remaining columns will be a breeze since they will be set up in the same manner just different number ranges, same colors will apply.

## Conditional Formatting - Two Different Fields Affect One Cells Formatting For Date?

Sep 16, 2013

A little background on what i am doing. I have a spreadsheet that tracks when i have blown the dust out of our computers. I have set up conditional formatting so that the text turns red after 300 days and the cell turns yellow after 600 days. However, some computers are in high dust environments. I would like the spreadsheet to tell me to blow the dust out of these sooner. see the attached sheet.

dust 1.xlsx

## Looping & Conditional Format: Finds A "J" It Will Apply Conditional Formatting To A Row Of 4 Cells Directly Adjacent?

Feb 9, 2009

I need to run a loop through a column of values (attachment col B) and when it finds a "J" it will apply conditional formatting to a row of 4 cells directly adjacent. The attachment is a theoretical before & after.

## Excel 2007 :: Conditional Formatting Empty Cells Based On Full Cells?

Nov 17, 2011

Working in Excel 2007. I am using excel for a data log (basically) and want it to format all empty cells in a row yellow if there is data in column A

Basically, If i have a value in A2, I want any empty cell between B2-G2 to be filled in yellow (as an idicator to the inputter that the cell needs to be completed).

there is already conditional formatting on these cells, which i want to maintain for the non-empty cells. I also have "0" as a value, so I couldn't use the basic conditional formatting setting it =0, it highlighted cells with \$0.00, which i do not want.

## Conditional Formatting: Cells Filled By Red Until The User Enters Text In Those Cells

Jul 18, 2006

Is there a way to set up a conditional format for several cells so that the cells are filled in with red until the user enters text in those cells??

## Conditional Or IF - Formatting Another Cells Font Based On Different Cells Text

May 3, 2013

What I am looking to do is;

If cell A2 = "Closed"

then I want cells B2 and C2 to strike through its own text.

I.E.
A2= anything other than "Closed"
then B2 and C2 = Blah blah blah

but if

A2 = Closed
then B2 and C2 = Blah blah blah

## Conditional Formatting Of Blank Cells And Date Cells?

Jan 17, 2013

I have attached the sample. I need the cells without the employee or without a boss to highlight a color and i also need the date of certification to highlight if it is more than one year old.

conditional formatting.xlsx

## Conditional Formatting Of Cells

Jul 3, 2009

I want to add some colour conditional formatting to the cells in column C, dependent on their variance to the figure in column B. I've got the basic gist of applying the rule to the one single cell, but I'm not sure how to apply it to all the cells in the column. I have tried "dragging" it down, but it then just gives me the variance to the original row.

## Conditional Formatting Cells Used To Sum

Apr 15, 2013

i want to know is there any way to set up conditional format to the cells used in a formula which is in another cell.

## Conditional Highlighting Of Rows?

Jun 24, 2014

I have a program that compiles a whole bunch of annual data.

The data is in columns A:J

I would like to have a program that loops through column A's entries and if the entries are odd then have the cells in Columns A through J of that row be highlighted with colour index RGB (193, 205, 205).

This is what I have below, but it is not working.

[Code] .....

## Reference Cells One To One In Conditional Formatting?

Jul 24, 2014

I'm using conditional formatting where one column of cells is referencing another column of cells. For example, I want cell K2 to highlight if the date entered doesn't match the date in F2. I then want cell K3 to highlight if the date entered doesn't match the date in F3. I want cell K4 to highlight if the date entered doesn't match the date in F4 and so on. I'm not having any issue putting conditional formatting on the cells/row references individually, but when I try to copy the formatting (by using format painter) to save time all of the cells in column K just reference the first cell in column F since the first cell in column K references that F cell but not any other F cell. How do I copy these row by row references between columns so that each reference is unique?

## Conditional Formatting Based On Another Cells Value?

Aug 18, 2014

On the attached worksheet I'm looking for the squares in F4:F6 to be coloured corresponding to the colour names in D4:D6 using conditional formatting. I just can't get it to work today.

## 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 Based On Cells?

Mar 30, 2014

I have a worksheet which has the years 2001 to 2013 on in row1. I am trying to find a way of highlighting the entire row in green if a specific year contains an "a" (Marlett, tick). The complex part is that I would like the specific year to be determined by an entry input into cell A2 on sheet 2. See Attachment for reference.

## Conditional Formatting In Merged Cells?

Aug 11, 2014

I am conditional formatting with fill colour based on specific text- the cells are merged down into a double cell- when the cell changes colour it goes half one colour and half another colour based on the order i have them in the rules- i only have them set to one colour per specific text and the text is all different- so why am i getting this half and half look?

## Conditional Formatting On Filtered Cells

Apr 23, 2009

Is it possible to apply conditional formating just on visible filtered cells?
If I select (with Ctrl+Shift+Down) all visible (by filter) cells the Rules defined in Conditional formating will also apply to hidden (by filter) cells?

## If Conditional Formatting (turning Those Cells Off)

Jun 9, 2009

what i want to do is say:

If A1="" then color B1 and C1 black, basically turning those cells off

## Conditional Formatting A Range Of Cells

Nov 26, 2009

I'd like my conditional formatting to format the range of cells red if the range K2:S2>H2. That is when the range K2:S2 are added together, and if their sum is greater than H2, format cells K2:S2 red.