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.

View 7 Replies


ADVERTISEMENT

Conditional Formatting - Borders

Jul 9, 2009

i am trying to do the following but having trouble getting my head around it!

if a2=0 then b2:b13=border

View 10 Replies View Related

Conditional Formatting Using Borders Between Unlike Cells

Feb 7, 2013

What is the formula to plug in a THICK border between unlike cells?

Example:
A B C
1 TOM BROWN CO. 2010 Sales $800
2 TOM BROWN CO. 2011 Sales $720
3 JANE SMITH CO. 2010 Sales $300
4 JANE SMITH CO. 2012 Sales $100
5 JANE SMITH CO. 2013 Sales $250
6 ABC CO. 2010 Sales $100

View 1 Replies View Related

Fill Down Option Not To Interrupt Conditional Formatting

Feb 10, 2014

Below is a code that works for this attachment Invoice.xlsm When you hit the code you will see how the 2 left most columns disrupt the conditional formatting resulting in one color for those columns as opposed to every second row with one color and the rows between them another color. modify this code so that the conditional formatting remains the same? (I highlighted the part in the code that needs attention).

[Code] ......

View 4 Replies View Related

Link Conditional Formatting To Option Buttons

Jul 1, 2007

I have created a calculator that you enter multiple data into. It gives me averages and standard deviations and such. With these results I have two different limits depending on the custumer that these results could ask for. What I was wondering is as follows: Is it possible to add two optionbuttons and then apply individual conditional formates to the buttons? So if I clicked button #1 it would pull a specified conditional format and if I clicked button #2 it would pull a different one. I have attached what I am working on so you can have a visual.

View 6 Replies View Related

Execl 2007 :: Conditional Formatting - How To Turn Off Stop If True Option

Jun 2, 2009

How can you use VBA code to turn off the annoying "Stop if True" default setting when doing conditional formatting in excel 2007? Right now when you have multiple conditional formatting conditions in a cell, it stops checking and formatting other conditions if one of those conditions is satisfied. I don't why they set this as the default...

I have conditional formatting rules set up using excel 2003. The file is opened in 2007 with the above-mentioned default setting that screws up all my conditional rules.

View 1 Replies View Related

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.

View 3 Replies View Related

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?

View 2 Replies View Related

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.

View 4 Replies View Related

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

View 6 Replies View Related

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.

View 10 Replies View Related

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

View 9 Replies View Related

How Do I Make A Msg Box With Out Any Option

Dec 29, 2009

I made a msg box but i dont want any option to be displayed in it.. it only should display as an info to the user.

View 9 Replies View Related

Make Check Boxes Behave As Option Buttons

Oct 27, 2009

I have a form with at about 1200 checkboxes and I need to make them behave as radio buttons. What I mean is that just one box can be selected in a group of boxes.

Lets say i want to group all 1200 boxes in 400 groups, with 3 check boxes in every group. I want user to be able to select just one check box in every group.

View 12 Replies View Related

Click Option Button To Make Cells Bold

Mar 25, 2007

Public Sub OptionButton1_click()
Sheet1.Select
ActiveSheet.OLEObjects("OptionButton1").Interior.Font.Bold = True

End Sub

The problem i have is when i click on one of the option buttons it should change the cells ive highlighted to bold.

View 9 Replies View Related

Option Button To Make Visible Multi Pages In Userform

Jul 6, 2013

I have a user form with multipage.

With the use of the option buttons,the page needs to made visible or invisible.

Example: on Page one, i have placed radio buttons as page2,Page3&page4.

By default only page 1 should be visible and when we select radio button page2, page2 should become visible or else it should be invisible,when we select radio button page3, page3 should become visible or else should remain invisible.

View 5 Replies View Related

ActiveX Option Button On Click Formatting?

Feb 26, 2013

I'm running into an issue with my ActiveX Option Buttons where they change appearance on click, rendering my transparent settings moot.

Here is an example of the process flow where a user decides to select 'New Visits' instead of 'All Visits':

Before click
before_zps37d416b4.png

After click
after_zps0e12e3e6.png

Here are the properties of the buttons:
properties_zps84fcff45.png

Is it possible to avoid this scenario?

View 1 Replies View Related

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

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

IF Statement Using Formatting Criteria (NOT Conditional Formatting)

May 5, 2009

Is there "code" for different formatting in a spreadsheet so you can use an IF statement to do something like:

if(A1=blue background,"Yes","No")

or

if(A1=red text,"Yes","No")

etc.?? But replace "blue background" and "red text" with some sort of number code? I want to compile a list of the items that are formatted with certain background colors and/or text colors and then organize only those items into a chart.

View 5 Replies View Related

VBA To Convert Conditional Formatting To Fixed Formatting?

Jul 5, 2013

Any VBA that I can put into a macro that will convert conditional formatting into fixed formatting..? So when the cell contents/formulas are deleted the formatting remains. Assume that the range I want to convert is A1:D200...

View 9 Replies View Related

How To Make A Conditional Median Function?

May 9, 2006

for my thesis i need to create median industry multipliers. i have a list of
companies with their industry codes and multiples, but now i need to create a
list with medians per industry. is there a function similar to SUMIF for
medians?

View 11 Replies View Related

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.

View 5 Replies View Related

Excel 2003 :: Make A Conditional Design For A Row?

Jan 20, 2013

I'd like to make a conditional design for a row. If a certain cell equals "x" I'd like to color the whole row with grey My version of excell is 2003

View 7 Replies View Related

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.

View 2 Replies View Related

Excel 2013 :: CF With 2 Option Buttons / Multiple Option Groups?

Sep 6, 2013

I have several option groups (Y & N in each) linked to cells to display TRUE / FALSE depending on which option is selected in each group. I have another cell which I want to apply conditional formatting to if EITHER Y or N is selected in all groups. At present I use COUNTIF to check for FALSE=0 in the linked cells which works if all the answers are Y. How do I apply CF if there is a mixture of Y & N (TRUE / FALSE) in all groups (I'm not sure if I've explained that well or not).

Excel 2013

View 1 Replies View Related

Address Formatting From Wordpad To Make Mailing List

Mar 11, 2013

I have a data set for over 9000 addresses and can't get it formatted the way I need to. Attached is a small version of the doc. I need colums with "Name, address, zip, state, etc." and need to get rid of any duplicate addresses. address mock1.xlsx.

The main issue i'm running into is some of the addresses are 3 rows, some are 4 or 5. If there is a way to group all the data automatically between the "----------------------" that seperate them I think the offset or concatenate tools might work?

This document was originally wordpad in this form and I don't neccesarily need all the data, mainly need to make a mailing list. address mock1.txt

View 2 Replies View Related

Formula For Conditional Rule To Make Row Change Colour Over Multiple Sheets

Jul 10, 2014

I want to change the colour of rows depending on the letter that is in a column. I want it to do it over all the sheets of the document. In the G column there will be letters like 'W' and 'L' that signify something and I want to make it clear by changing the row colour fill. I've tried a few formulas I found by googling but they didn't work. I should point out that the letters are connected, so if I put a 'W' on the second sheet it appears on the first sheet as well.

View 2 Replies View Related

Conditional Formatting - More Than 3

Dec 9, 2008

In a column, there are 4 option for each cell -
"PAYMENT DUE"
"PAID"
"UNDERPAID BY..."
'OVERPAID BY..."

These are filled in by a formula

I would like to make them 4 different colours but excel only allows 3 options

View 14 Replies View Related

If Then Or Conditional Formatting??

Mar 5, 2009

I have a hard time when it comes to "If then" statements and conditional formatting. I have some data that I am collecting and entering into a spreadsheet for a couple different companies. Once I receive paperwork from those companies for the data collected I mark the data with a blue colored text. I would like to have a second sheet that generates what companies have not sent me their paperwork. "If the data is black text, then generate <name of company> on second sheet." The list is small right now, but as the project continues it will grow very large and it will become difficult to track. I will attach a copy of the spreadsheet for you to see the situation. I would like to learn how to do these types of formulas, is there a tutorial geared towards these types of situations?

View 2 Replies View Related







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