# Conditional Formatting :: Make Cell Blue After 90 Days Passed

Jan 19, 2010

This might be a simple answer but... if A1 had the date 1-Jan-2010, what formula would I used, within conditional formatting, to make that cell turn blue once 90 has passed? So the cell should turn blue on 1-Apr-2010.

## Excel 2007 :: Conditional Formatting Dates Based On Number Of Days That Have Passed?

Nov 22, 2011

I am trying to figure-out how to set up conditional formatting of dates in a column (e.g. Date Submitted) and have these dates, and/or cell, change color as time progresses. I have Excel 2007.

For instance I have an application submitted on 11/20/2011 in a cell. I would like to have the date change color (Yellow) after 30 days have passed.

Then do the same except change to Red after 60 days have passed the date.

I searched the forums and did not find this particular problem. I of course may have missed it too...

My guess was to try "\$A\$1

## Months Have Passed Irregardless The Number Of Days Passed

Mar 5, 2010

I need a formula to calculate how many months has passed irregardless how many days had passed. What I mean by that is if I have a starting date of 1/31/2010 and an end date of 2/1/28/2010, that should count as 1 month passed. I tried using the DATEDIF function, but that function is counting number of days, so if only 28 days had passed, that would not count as 1 month.

## Macro To Make A Cell Background Blank If It Is Not Orange Or Dark Blue?

Apr 17, 2008

Does anyone know how to use a macro to make a cell background blank if it is not orange or dark blue?

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

## Make All Blank Cells Blue?

Mar 20, 2009

I want to make all the cells that are outputted as blank by my formula a certain color to distinguish them from non blank cells. my current formula: [B1=IF(A1=0,"",A1)]. my guess would be to use an [AND] function but I do not know how to command a cell to change color without using the toolbar.

## Formula To Get Number Of Passed Days

Feb 15, 2010

I have a formula which calculates number of days remaining. But I need a formula to to know how many days passed after a particular date.

Example :-

Date .Days passed
10-Feb-2010 .6

=IF(ISBLANK(G14),"",IF(TODAY() > G14,"LIC EXPIRED",G14-TODAY()))

## Conditional Formatting - Certain Days In A Calendar

Sep 4, 2013

I have a calendar for the whole year made. I want every Wednesday to be highlighted. I wanted a conditional format to do this as I will be doing multiple calendars and I do not want to manually highlight every individual cell.

## Conditional Formatting For The Number Of Working Days

Jan 7, 2009

I am trying to do a conditional formatting for the number of working days. What I am trying to do is:

Example:

As in the row D7 I give the actual workdays required to finish the task the Gantt Chart gets a specific formatting on the right appears for the number of working days.

Problem:

I want to avoid the formatting if there are any weekend (Saturday or sunday)

Suppose I give number of working days as 20 then there would be 6 weekend days so it shall add to the overall actual working days but again sinnce we are adding 6 additional days one more weekend day would come in between so the formatting shall take care of this.

## Conditional Formatting To Color Days In A Calendar....

Jan 19, 2010

I have this SS that uses conditional formatting to color days in a calendar, dates are entered in columns B & C when the dates are entered then the days of the month highlight. Everything works great but I can not get the conditional formatting to work in column E. Column E would be January 1. If I enter Jan 1 in column B & Jan 30 in column C all the days highlight except Jan 1? I have uploaded the SS.

## Formula + Conditional Formatting For No Of Days Before Due Date

Oct 5, 2007

Heres what I am trying to do:

I have a due date of 30/10/2007 in cell A2, I would like the cells in row 2 to change to the colour green 15 days before the due date (15/10/2007) and then I would like Row 2 to change to the colour Amber 10 days before the due date (20/10/2007).

This is what I was trying to do but it is not working for me:

____A_______________B__________C
1___Due Date________15__________10
2___30/10/2007______=a2-b1______=a2-c1

The Formula in B2 and C2 work fine.

I was then thinking that I could put a formula in Conditional formatting that says something like
If todays date is equal to b2 then Green else do nothing or If todays date is equal to c2 then Amber else do nothing

I can't figure out the formula for that though.

## Conditional Formatting To Highlight 2 Days Before The Expiry Date

Sep 4, 2009

I have a list of items which are supplied by 3 persons and these items have expiry date. I want the Conditional Formatting to highlight 2 days before its expiry date. I have managed to set only for dave, how do I set for the other two persons? FYI, each item is only supplied by one person.

## Conditional Formatting To Make Dues Dates

May 9, 2014

I look everywhere to find a formula for a conditional formatting to make dues dates.

I would like to know if it's possible to do conditional formatting to make due dates turn green and yellow 90 and 180 days before their dues dates? The reason I am asking this question, it's because the column that where dates are, they are coming from a VLOOKUP formula and it's coming from another workbook.

## How To Make Conditional Formatting For Negative Numbers

Feb 19, 2014

I need the conditional formatting to make all numbers that are zero clear (i.e. no fill).

I need it to make all negative numbers to be red, however it doesn't seem to recognize "-1" as a number, and ends up highlight everything red when I say "highlight values < -1 red".

How would I do this?

## How To Make Excel Carry Over Conditional Formatting

Mar 27, 2013

Conditional formatting format: Boarder - bottom boarder

The problem when I insert a raw in the middle of the table the condition formatting is not applied. How can I make excel carry over the conditional formatting?

The only reason I formatted the data in a table because it'll automatically control alternating row background color when insert rows.

## Make Thicker Borders Using Conditional Formatting Option?

Jun 26, 2002

how to make thicker borders using the Conditional Formatting option? The options they give you are all thin borders.

## Excel 2007 :: Auto Lock Rows 6 Days After Date Passed

Jul 30, 2014

I am new to Excel programming, haven't done any before and not familiar with creating/editing macros. Using Excel 2007.

I would like to automatically lock all the cells in a row if the date in column A in that row is >= 7 days old. Data is entered once a week (some time Sunday - Saturday) and I would like historical data (rows) to be locked so that they can't be edited inadvertently.

If possible could I also highlight the current working week somehow?

I have attached the worksheet : testworksheet.xlsx

## Conditional Formatting And A VBA Code To Make Sure The Cond. Form Is NOT Active

Nov 5, 2008

I am trying to add something to a spreadsheet. I want to do some Conditional Formatting but I am not certain on what the formula would be to accomplish it. I am putting the Cond Format in cell E5 and I need a formula to say: IF F5 AND G5 are BLANK then do the format I set up which is simply to fill the cell with RED. (.ColorIndex = 3)

The next portion of my problem is I need to revise my VBA Coding to check and make sure that there is not any cells in Column E that have the Formatting Active. This is the portion of code I need to alter. I have changed the wording of the message but am not sure on how to change the IF statement:

'Checks to see make sure there are no Actions or Resolutions WITHOUT a Topic

If Sheets("Meeting Minutes").Range("C1").Value = "" Then 'NEEDS TO CHANGE

MsgBox "Oops! You forgot to enter a Topic for Discussion in a cell(s). You MUST have a Topic in order for your Meeting Minutes to transfer to the Master sheet." & vbCr & vbCr & "Please click OK to return to the Minutes sheet so that you may fill in the Topic(s).", vbOKOnly, "CAUTION! PLEASE Note!"

Range("D5").Select
Application.ScreenUpdating = True
Application.StatusBar = ""
Exit Sub
End If

## Conditional Formate: Fill Is Light Blue And Bottom Line Solid

Feb 14, 2010

Using 2003, I'm trying to do the following, data starting in A3, and ending in L3:-

- If A3 is blank, cells have no format
- If A3 has a value, with A4 blank, fill is light blue and bottom line solid, top line dotted
- If A3 has a value, and A4 does too, fill is light blue, top and bottom line dotted
- If H3, which is a date field, is greater than today font is black, if less than today, font is red

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

## Formatting Cell To Show Days Instead Of Hours

Aug 12, 2013

I have a formula that returns me a result in hours. I have a result of 1712 hours but when i try and formatt the cell to show days is says 11. (Which obviosuly isnt right)

Is there anyway to show the correct number of days?

## How To Make Formatting Rule Permanent To Cell

Apr 21, 2014

How do i make a formatting rule permanent to certain cell's.

The steps i followed:

I selected the columns and rows to be formatted. in conditional formatting I selected new rule. then selected the second function, "format only cells that contain" in format only cells with: specific Text , then " ending with" Over Issues.

in format i selected the font and fill.

I saved and close the document, after reopening the rule is no longer working.

## Conditional Formatting From Another Cell

Jan 8, 2009

A1 is not in any pattern colour. But if A1 is changed into, say, Red, B1 will be equils to D5+F5. Otherwise if A1 is changed into Blue, B1 will be equils to D6+F6. Can it been done by Excel 2003?

## Conditional Formatting In Cell

Jul 7, 2007

I have a conditional format in Cell J3 that has 2 conditions as follows:
Condition 1: Cell Value, Equal to, ="NO", and then the format will color the cell RED.
Condition 2: Cell Value, Equal to, ="YES", and then the format will color the cell GREEN.

I want Condition 3 to turn the cell J3 YELLOW if there is ANYTHING at all or anything above "0" typed into Cell D3.

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

## Conditional Formatting - Hide Value From Cell Until It Changes

Apr 12, 2014

I have a formula as follows:- B20 is the cell I wish to format. The formular is =B18-400. My problem is I wish to hide the -400 from the cell until it changes.

## Conditional Formatting Referencing A Second Cell?

May 22, 2014

If the value in column AE falls below 100 it needs to turn yellow. If the value drops below 50 it needs to turn red.

But if the figure in column AB is 0 then i dont want it to do anything at all.

## 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 Using Cell Reference?

Jun 3, 2014

i want to calculate percentage between A and B and highlight top 10 values in B.

as of now i am calculating % in C and applied conditional formatting in C. filtering C based on color i am formatting B manually.

is there any option to avoid this manual work.

Total countAlarm reported%
562545%
783545%
322578%

## Conditional Formatting On Cell Based On Value

Jul 29, 2014

In Excel, I want to do conditional formatting on a cell based on the value of another cell. For example: in cell A1, I have text. I want this cell to have a grey background if the value of cell B1 is less than or equal to 1/31/14 and to have no fill (default) if it is greater than that date.