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

## Conditional Formatting To Highlight Cells With Formulas

Dec 29, 2008

I have searched for a while but can't seem to find where the original thread is at. Could someone point me in the right direction?

## Conditional Formatting To Highlight Cells With Formulas (versus Constants)

Nov 24, 2010

Is it possible to use conditional formatting to highlight cells that use formulas, as opposed to having constants?

I have a sheet that uses formulas to provide a default value, but you can type in a number if you want to replace the default. I want to be able to easily identify which ones use the default formula.

If I use functions like FIND, they look at the result of a formula, and not the formula itself.

I know I can write a UDF that will figure it out but I was wondering if there is some built-in way.

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

## Conditional Format (with Formulas) 10 Cells Depending On 1 Criteria

Oct 19, 2009

I want to colour 10 cells (A1-J1) if I type in yes in cell K1. Using conditional formatting Im only able to colour 1 cell. Is this possible without using VBA?

## Format Formulas, Constants, Numbers & Text Cells Differently

May 8, 2008

I am attempting to write a VBA function that will add textual formatting to each cell that has content. I am just learning VBA; so far, as an example I have

Sub NewSub()
i = 1
j = 1
Do
Cells(i, j) = "'" & Range(i.j).Value & "',"
i = i + 1
Loop Until i = 40
End Sub

but, as I'm sure you'll notice, it does not work. In essence I want to wrap quotes and follow with a comma each cell that contains any content. The actual content test I haven't gotten to yet.

## Conditional Format Cells Containing Numbers And Letters - Ignore Cells With Number Only

Jul 11, 2014

I have a column of numbers and want to make sure everything has been entered correctly from our scanning software. Basically, I want to automatically highlight any cell that has any letter in it (e.g. z12o2 instead of 21202 or R705 instead of 5705), ignoring any cells that contain only numbers. I haven't had any luck using conditions based on formulas like =ISTEXT.

## Conditional Format - Compare To An Adjacent Column Of Numbers

Sep 15, 2009

I have a column of numbers (column A) which I'd like to compare to an adjacent column of numbers (column B) and, by row, determine if the number is larger.

If it is, I'd like to place a different colour on the cell. What is the formula I need to use to accomplish this?

Ex:
Col A Col B
30,000 5,000 - A is larger than B, therefore A is formatted RED
20,000 20,000 - A is the same as B, therefore no format applied
10,000 15,000 - A is less than B, therefore A is formatted GREEN

## Conditional Formatting A Column And Highlight The Cells That Fall Within The Top 20%

Sep 16, 2009

I have a spreadsheet showing names, quality percentages and times taken to answer a call in 3 columns. I would like to highlight the cells that fall within the top 20% of those shown (e.g. if there are 100 quality percentages I want to highlight the top 20 not those over 80%) also the same with call length.

I have a column of numbers and times (mins and secs) and what would like to do is set a conditional format so that the cell turns a colour when the number of any cell is within the highest 20% and the other column turns a different colour when the time is within the lowest 20%.

## Get Cells In Column F To Highlight All Negative Numbers?

Apr 6, 2014

How do I get the cells in column "F" to highlight all negative numbers UNLESS the following 2 conditions are met: the number in column F = "-105" AND there is an "@" corresponding in column "C". In the attached file F5 & F7 are highlighted properly according to what I want, but F6 is not (since F6's value is "-105" AND C6's value contains an "@").

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

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

## Payroll Spreadsheet - Highlight Cells That Have Hours Entered For Vacation

Jun 18, 2014

I have a payroll spreadsheet and I want to highlight cells that have hours entered for vacation. For example, in cell E4 I put the job name which is "VACATION" and in cells G4 through M4 I put the hours in for each day. (G4 is Monday, H4 is Tuesday, etc.)

I tried to put a conditional formatting using the following formula ="IF(E4=""VACATION"")" then I chose the fill color however it is not working.

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

## Conditional Format To Highlight Current Year Only?

Oct 15, 2013

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

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

## Conditional Format Cells In Jan - Dec Columns Based On Next Column Data?

Jan 29, 2014

Wondering if it is possible to conditional format cells in "Jan"-"Dec" columns based on "Next" column data?

What I need is (lets say fill colour to differ) in one cell per row, based on latest input and "next" data.

Month Avg
Date
Jan
Feb
Mar
Apr
May
Jun
Jul

[code]......

So for example:

row2: May is latest input so need fill in cell +2("next" column data) from may. In this case July

row3: Feb is latest imput and "next" also 2. Result should be Apr

row8:May is latest input, "next" is 6. Res should be Nov.

Finally, only one cell per row to be highlighted so need to overwrite colour fill when new data input in a cell already colour filled.

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

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

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

## Conditional Formatting - Highlight Numbers In Data Group

Mar 25, 2013

How do I do "conditional formatting" to high light the numbers which bigger than average + 2 * stdev in a data group?

## Excel 2007 :: Conditional Format With Formulas?

Feb 27, 2013

Is it possible to conditional format cells with formulas in Excel 2007. It used to be possible in Excel 2003 but I'm struggling to find this in the new version.

## Color Format On Numbers Vs Formulas

Dec 3, 2007

Is there a way, WITHOUT VBA, to have a cell turn color if a user overlays a function with a value. Using conditional formatting or an easier way if possible, I would like to have any cells that the user overlays with a number to have a different background color.

I know I could use an event-driven macro but am trying to find a function that can check a cell to see if it contains a formula (or function) or a value.

## Cancel Conditional Formatting If Date Entered In Column

Jul 2, 2014

Cells in Column F change colour under certain conditions. How do I cancel or apply no format to cells in Column F if any date is entered in Column G.

## Compare Two Worksheets (including Formulas) And Highlight Different Cells

Oct 17, 2012

I want to design a macro that will compare the student's completed worksheet to the model answer worksheet. This will allow the class to work at different paces depending on ability.

For each exercise, the two sheets should look identical; and so, I would like the macro to highlight any different cells in the student sheet in a colour. I would also like cells with identical values, but different formulas to be highlighted - this is why I could not use the solution posted in : "Compare two worksheets and highlight the one sheet's difference from the other one".

## Compare Column A To Column B Then Highlight / Format Any Duplicates

Mar 17, 2014

Trying to compare a list of names in 2 columns. Column A has a short list of names I'm looking for in the long list of Column B.

How can you create the macro that does...

If any value in Column A matches any value in Column B

Then format (bold, highlight, etc...)

## Format Random Number Cells As Draw Result Entered

Nov 17, 2008

Format Random Number Cells As Draw Result Entered ...

## Keeping Cells With Formula And Conditional Formatting Blank Until Data Entered?

Feb 22, 2013

I have a spreadsheet filled with formulas that depend on a value being entered into A2, A3, A4, etc... So column A starting at A2 is where I will manually input a number and the formulas I have in columns B, C, and D will import information from another sheet based off what is put in column A. In column D the formula I have to import data

is =IFERROR(VLOOKUP(A2,Master!C:M,11,0),"").

This will import another number. Additionally in column D, I have conditional formatting that will return a red, yellow or green light based off the rule I have in place. Everything works fine, the only problem is that column D has a green light all the way down even without a value being placed in column A. I would like to find out a way to keep the cells in column D blank until a value is entered in column A. Also, if I go back and delete the value in column A, I would like the corresponding cell in column D to go back to blank as well.

## Highlight Cells Using Conditional Formatting

Apr 5, 2013

conditional highlighting.PNG

Is there a way I can have excel automatically highlight all cells within A1:A3, B1:B3, C1:C3 if and only if they are greater than the percentage in E5? If so how would I go about doing this?

## Conditional Formatting : Highlight THE CELLS

May 16, 2008

I need to hightlight from A1:A18

In the above cells I have values from 1 to 4

So I need to fill the cell with 4 different colours.

If cell equals 1 = Green
If cell equals 2 = Yellow
If cell equals 3 = Red
If cell equals 4 = Blue

What I do is highlight cell from A1:A18, clik on 'Format', 'Conditional Formatting', I've tried using 'Cells Value is' and 'Formula is'.