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


ADVERTISEMENT

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

Conditional Format: Highlight A Cell If Any Cell In The Range To The Right Was Greater Than Zero

Mar 28, 2007

If I wanted to highlight a cell if any cell in the range to the right was greater than zero, what formula would i use. I have tried =IF(L1:AD1>0,1) with the result returning for only the cells in column L. Row 3 has no value in column L but a value in column N with no result to highlight the cell.

View 4 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

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

View 3 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

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

Conditional Format (highlight Each April)

Sep 17, 2009

I'm trying to do something rather easy (I think). I would like to conditional format a column of historical dates. In this column I would like to highlight the first month of each fiscal year (April).

I'm unsure how to type this in logically into the conditional format formula? (Excel 2007).

I tried "=Month()=4" which does not work. Sometimes I wish we could just use simple algebra to do excel functions! A=Month(x) when A = 4, format cell!

Any ideas?

View 7 Replies View Related

Conditional Format To Highlight Anything That Is Not Whole Number?

Feb 24, 2014

I want to know if there is any way to highlight a cell that does not contain a whole number. In my spreadsheet I have a formula that calculates the number of packages in an order, but if the result is not a whole number then I want it to be highlighted.

View 4 Replies View Related

Conditional Format To Highlight Current Year Only?

Oct 15, 2013

Formula to conditional format to highlight all the dates only showing 2013?

View 3 Replies View Related

Conditional Format Rows To Highlight Every Other Row With A Value Different Than Previous

Feb 11, 2014

do a conditional format rule that will highlight every other row of my excel spreadsheet when the value in a specific Column (say Column A) differs than the previous.

I've attached a sample worksheet with what I want it to look like after the conditional format rule is applied (every other row highlighted in light blue). The rule needs to apply to all rows in the worksheet beginning with ROW 2 (I don't need the rule to apply to the column header which is in ROW 1).

View 4 Replies View Related

Conditional Format - Highlight Cells If They Are Duplicated

Aug 27, 2013

Two things in Conditional Format, any formula to highlight cells if they are duplicated, but the next set of duplicates in another color? i.e.

If that isn't possible just the formula to highlight A To C would be great

So Cells A1 to C1 (red) and cells F! to I1 (Blue)

A1 500
B1 500
C1 500
D1 500
E1 650
F1 750
G1 750
H1 750
I1 750

View 3 Replies View Related

Conditional Format Based On Cell Value - VBA

Jan 17, 2014

With the click of a toolbar button, I've got my vba inserting a new tab, renaming it, inserting headers and now working on the code to insert all the formulas needed in 12 columns to copy down as far as there is data.

The 4th column D is the hardest. Currently, I'm using manual "Conditional Formatting" to colorize the cells in Col D but need the VBA to place that "Conditional Formatting" code into the sheet so that when the sheet is created, it will hold the conditional formatting feature.

Specifically, the formulas I'm using in the Conditional format wizard are:

Formula: =$B2$D2 then turn the cell red Applies to: =$D$2:D

Copy down (in other words, the colorizing should work all the way down Column D as long as there is data in Col D.

View 2 Replies View Related

Conditional Format Row Based On Cell Value - VBA

Jul 23, 2014

How to write a VBA that will, if the value of a cell in column "U" is TRUE, that row's FONT (for the row the TRUE cell is in) will turn red.

View 4 Replies View Related

Conditional Format Cell Based On Value Of Another

Feb 19, 2007

I'm afraid as its a multiple conditional format and thus needs coding. At the moment I'm using the following

Private Sub Worksheet_Change(ByVal Target As Range)
' Conditional Formatting for more than 3 conditions
Dim rng As Range
' Target is a range::therefore,it can be more than one cell
' For example,,someone could delete the contents of a range,
' or someone could enter an array..
Set rng = Intersect(Target, Range("E27:E34,G27:G34,I27:I34,K27:K34,M27:M34,O27:O34,Q27:Q34,S27:S34,U27:U34,W27:W34,Y27:Y34,AA27:AA34"))

If rng Is Nothing Then
Exit Sub
Else.....................

This works very nicely, so that for example if I type the number 10 into cell M33, that cells fill colour becomes black (and the text turns white). Alas I would now also like to extend the fill and text colour to the cell one to the left too. To take this example I would type 10 into cell M33 and cells L33 and M33 would both be filled black and their text would be white. I'm not sure if this requires a change to the code, or if its possible to just have a formula or something which copies the fomatting of one cell into another

View 2 Replies View Related

Conditional Format Highlight The Highest 3 Perecentages In A List

Oct 14, 2009

I've creating a sheet to keep track of quality for my department. What i want excel to do is highlight via conditional format the highest 3 percentages in collum.

Example

85%
90%
91%
99.25%
96%
87%

What i want is to have 99.25%,96, and 91% change to green since they are the highest %

View 6 Replies View Related

Conditional Formatting Based Upon Format Of Another Cell?

Mar 25, 2010

Is it possible to format a cell based upon the format of another cell? For instance, if the cell to the left of a target cell is bold, is there a conditional formatting cell that can be used so that the target cell is bold as well?

View 8 Replies View Related

Conditional Format One Cell Based On A Date?

Jan 18, 2013

I have two cells. both formatted to contain dates.

cell a1 will have a date in it. cell a2 will have a date calculated to be cell a1 + 42 days.

now, when cell a2 reaches a date that is greater than cell a1 + 42 i want cell a2 to be formatted as fill red.

so, i have tried a conditional format as =a1+42 >=TODAY() but it always highlights as red even if the value in cell a2 is less than cell a1+42.

View 5 Replies View Related

Conditional Format Entire Row Based On One Cell

Mar 13, 2013

I want to highlight an entire row based on the contents of of a particular cell. For instance, if c4 contains data, highlight the entire row 4. If c5 is blank, do not highlight the entire row 5...and on and on...

View 2 Replies View Related

CONDITIONAL FORMATTING TO VBA. Row Format Based On Cell Value

Apr 19, 2008

I have set 3 conditional formatting rules where the row from column A to K will change depending on the value on column L.

Selection is equal to A3:K100, conditions are similar to:
- Formula is =$K3="PIP"

Then for formatting I chose WHITE BOLD FONT & BLUE SOLID PATTERN, for example.

Conditional formatting only allows 3 conditions. If this can be replicated
using VBA, then you can set "n" conditions, correct?

View 9 Replies View Related

Conditional Format Cell Based On AND/OR Condition Of Another

Feb 8, 2008

i m trying to format a cell so that it colours in red when a specific text is chosen in another cell, ive tried conditional formatting but I cannot get it to work. e.g column A has a drop down list, if GB or IEN is chosen in that cell then cell in column K will become red. (as if these two are chosen then they have to input a number into column K). Once they have inputted the number into column K i want it to go back to its original format. Or if they dont select GB or IEN then it would stay in its original format aswell.

View 2 Replies View Related

Excel 2010 :: Conditional Format Formula - Highlight Over 14 Days

Feb 26, 2014

I need conditional format in column Q which highlight in red, any date over 14 days old.

This column also contains texts (non-dates) and these need to be left alone.

I've experimented with a few bits of formula I've found online, but nothing has worked . .

I'm on Excel 2010.

View 3 Replies View Related

Using Conditional Formatting To Format Range Based On One Cell

May 20, 2009

I am working with the Conditional Formatting, which is fine for one cell. Here is what I am trying to do: IF cell in $A1 = 1 then bold $B2:$M2 and apply solid line border to top of cell ranges. I have tried conditional formatting but it only formats the cells in column A. And I can't seem to find a BOLD statement for the cell formulas.

View 2 Replies View Related

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?

View 5 Replies View Related

Conditional Format Entire Column Based On One Cell Not Having A Value

Nov 22, 2013

I need to make an entire column formatless if the cell in row 3 contains no text. I want the whole column to just appear like a normal formatless column, but if there is text in the row 3 cell, I want it to be the way I have it formatted right now.

View 1 Replies View Related

Conditional Number Format Based On The Value Of A Specific Cell

May 9, 2009

I have a large spreadsheet which includes many rows whose number format needs to change depending on the value of a specific cell.

So for example:

If cell B20 has value "A", cells Q20:AG20 should display as 1,234
If cell B20 has value "B", cells Q20:AG20 should display as 5.6%
If cell B20 has value "C", cells Q20:AG20 should display as 7.89
Etc...

As conditional formatting does not seem to include a number format option I've worked out that I need some sort of macro to change these settings for me, either automatically whenever the value of B20 changes or, more likely, when I manually choose to run the macro.

View 9 Replies View Related

Conditional Format Based On A Text Range Within A Cell

Nov 11, 2009

conditional format formula that is based on a text range within a cell. In my case, I would like to compare the low and high range when inputted as a number followed by the quotation marks followed by space then hyphen, space then number and ending in quotation marks. The quotation mark is being used to represent inches.

Like this in cell D14: 0.2” - 2.2”

I am using the following condition format formula which works for the strict case above.

HTML =OR(D16<LEFT($D$14,3)+0,D16>MID($D$14,8,3)+0)
However, there will be times when users using this spreadsheet may leave out the spaces on either side of the hyphen, or add more than one space between the number and hyphen. Also if additional digits are added, my formula above does not include all the digits in the results. I prefer to leave the quotation marks in...........

View 9 Replies View Related

Conditional Format - Highlight Cells In Column That Have Entered Numbers Rather Than Formulas

May 29, 2013

Col A - budget items (description)
Col B - budget dollars
Col C - actual dollars
Row 10 - summation Cols B and C

When the budget is prepared the actual dollars in Col C are equal to the budget dollars for all items. For instance the formula =b2 is placed in cell C2. As time passes the user records actual dollars in Col C for each item by entering the actual amount directly into the cell. Actual dollars do not become known all at the same time, so that Col C will contain a mixture of formulas and entered numbers.

How can I highlight the cells in Col C that have entered numbers rather than formulas.

View 1 Replies View Related

Conditional Format X Number Of Cells Based On A Single Cell?

May 4, 2014

I am looking for a method to conditionally format a variable number of cells below a single cell into which data is entered.

For example ABC = 6, DEF = 12. Therefore, if I enter ABC into D1 then D1:D6 should be conditionally formatted.

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







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