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

## Conditional Formating By Date

Oct 20, 2009

I have been trying to perform a conditional format using a date value.

Example:
Condition 1 =IF(L14

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

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

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

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

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

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

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

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

## Place The Actual Date In A Cell

Oct 22, 2007

Place the actual date in a cell. Here is my code

## Place Date In Cell H6 Automatically

Jan 9, 2010

I have the following
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A2:A100")) Is Nothing Then
With Target(1, 2)
.Value = Date
.EntireColumn.AutoFit
End With
End If

End Sub

I just want the date to appear in cell H6 autmatically and the time to appear in H7.

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

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

## Place Date Stamp In Cell Comment Using VBA?

May 30, 2014

My goal on the form is simply that when you click the check-box, it will highlight the cell green and place the date in the cell comment, and then clear the comment and color when unchecked.

I have been successful with the exception that I can only place text in the comment, but not a date stamp or even a reference to a hidden cell. I accomplished a date stamp command on a button with "Sheets("Sheet1").Range("Q5").Value = Date" but am unable to do this in a comment.

Below is what I have currently. I know it is not clean to look at, but that is how I found it and didn't want to create more variables for troubleshooting

Private Sub CheckBox1_Change()
Sheets("Sheet1").Range("Q4").Interior.Color = RGB(255, 255, 255)

[Code]....

I came across a couple results that seemed promising, but the code seemed to have a different syntax and I couldn't make it work with my VBA newbie skill level (started yesterday).

## Place Month Of Date Cell On Another Worksheet

Feb 6, 2008

I have two workbooks, one a database that accumulates data over time, and the other a monthly report that needs to be populated based on information from the database. When moving data between the two, the following works fine (snipped a lot for ease of reading):

Workbooks(reportbook). Sheets("Sheet1"). Range("A1").Value = month(Cells(282, 5))

As you can see, it simply puts the month from a cell in the database into the report workbook. However, if I change Range("A1") to Cells(1,1) I get a runtime error:

Workbooks(reportbook).Sheets("Sheet1").Cells(1, 1).Value = month(Cells(282, 5))

I can generally work around this issue by changing the active workbook, but doing so is a big pain. Is there any way to use the second bit of code without popping an error message?

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

## Set Up Formula In Conditional Formating

Dec 29, 2009

I want to set up formula in conditional formating so that when:

\$AF6 = "CA" the color is red
or
if \$AF6 = ("GA","ME","PR") then the color is blue

what I came up with is Condition 1
= (\$AF6 ="ca") [which will turn the cell red]
Condition 2
="OR(\$AF6={""GA"",""ME"",""PR""}, "")" [which doesn't do anything]

## Conditional Formating For 6 Conditions

Jun 4, 2008

B4:B193 - place
D4:D193 - value
F4:F193 - name

H4:H193 - place
J4:J193 - value
L4:L193 - name

N9:N93 - place
P9:P93 - value
Q9:Q93 - name

What i am looking for is this:

If value in cell in column D is >=90 then relevant cell in column B, D and F background green

If value in cell in column D is less =80 then relevant cell in column B, D, and F background dark blue

If value in cell in column D is less =70 then relevant cell in column B, D, and F background light blue

If value in cell in column D is less =50 then relevant cell in column B, D, and F background orange

If value in cell in column D is less

## Conditional Formating In 2003

Sep 11, 2008

http://www.mrexcel.com/forum/showthr...itional+format

Asks almost exactly the question I have, but I can't make heads or tails out of the answers, I'm guessing becasue I have Excel 2003 and not 2007 as mentioned in the replies.

In column "A" I have a number; column "B" the formula =A1 copied on down and in column "C" either a 1 or 2 or a 3.

If the number in column "C" is a 1 then the font in the same cell in Column "B" should be black, 2 Blue and 3 Red.

I'm thinking this should be very simple, but so far it's not turning out that way. )-:

## Conditional Formating On Graphs

Jun 10, 2006

if its possible to run conditional formating on graphs, I can do this fine on the actual data

i.e. Have a bar chart with a number of bars all the same colour and just wanted to have the bars change to red if they drop below a certain percentage.

only running excel 2000

## Conditional Formating: Spell Check

Jul 29, 2008

I am working on code breaking, and am working on trying multiple letter combinations, and was wondering if I could spell check the results and have that identify letter combinations that ARE words.

## Conditional Formating On Text Values

Jan 9, 2009

Been hunting around the forums but cant seem to find quite what I want.

I want to specify the background of a cell to be red if the text in that cell contains a specific word.

e.g. cell a1 will have the text 'Rest of World' (without quotes). I want this to show as red if it contains the word 'of'.

Of course the cell may contain other words but this illustrates what I'm looking to achieve.

I tried the following conditional formula but this does not work:

=IF(SEARCH("of",H3)>1,1,0)

## Conditional Formating: If & And Type Statements

Jun 11, 2009

I have tried a variety of if & and type statements but I cannot get this 2 conditional format to work. Review attached spreadsheet.

## Conditional Formating Using Match Function

Nov 12, 2009

I am having many difficulties getting conditional formatting using the match function to work correctly in my excel document.

What I would like to accomplish is as follows in the 3Q09 tab. If a subdivision name is found in C-62 through C-70 and a match is found for the subdivision name in AB-24 to AB-66 I would like it so the AB-24 to AB-66 Subdivision name is bolded for every match. I removed the function formulas from the 3q09 tab I used to have since they didnt work and I do not want to confuse anyone.

This is correctly done on the "Working Correctly" Tab included in the same file, so please view this for clarification if you need it. Why it works on one tab and not the other simply baffles me.

## Conditional Formating Pass Or Fail

Dec 15, 2008

I looked around the forum for a answer but none are quite the same. AA2 contains a date. AN2 contains a Pass or Fail based on =IF(AH4<60,"FAIL",IF(AJ4<60,"FAIL",IF(AL4<60,"FAIL","PASS"))).

Now even if those above fields are empty and no date is in AA2 "PASS" still shows up in AN2. I used =\$AA\$5="" to make AN2 turn white if AA2 had no date in it. I am unable to copy the formatting along the rest of the AN column without it all refering to just AA2. Is there a way to make it copy and correct the formating like it does with formulas? I had planned to due the same thing with the AO column that contains "DUE" if the person has not taken a test in 180 days. =IF(AA2<=(TODAY()-180),"DUE",IF(AA2<=(TODAY()-150),"CLOSE",IF(AN2="FAIL","RETEST","")))

## Match Index And Conditional Formating

Feb 26, 2010

I have a table I use visually, and I put it in a spreadsheet. Instead of finding a table value based on row and column label decisions, I use it as follows. I decide the row by matching exactly the height, h = 8 ft. In that row, I match the next larger value of 10 kips, in this case the value is 12.72; I then pick the column header label, in this case the value is 4 x 8.

I don't know how to make"B8:L8" equivalent to "B"&3+row : "L"&3+row in the 2nd Match formula?

## Conditional Formating Merge The Cells

Apr 25, 2007

is there a way to merge cells when conditional formating them

example if a1- team then it will be 2 cells
if a1 = player then it will be 1 cell?

## Insert Text With Conditional Formating

Jan 9, 2008

I have a list of numbers say in column A, but when the number "41", "25", "90", or "92" is in that column, I want a text message to print 6 columns to the right of it (same row) that says "service".

## Conditional Formating Or Change Events

Jan 11, 2008

I have a worksheet that I would like to color a range of cell within a row whenever the value of a certain cell in that row changes. For example, if cell A3 have a value of East that row color will be Blue with white fonts, if value is West the row color will be Green with Black fonts, if value is North the row color will be Red with Yellow fonts. This should apply to any row whenever the value is Column A is changed.