Topic profile page for Conditional.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Conditional.
Topic "Conditional" was discussed 53,780 times on 3,230 sites in last 3 months
Started 9 hours, 48 minutes ago (2009-11-27 00:26:00)
by Keyrookie
Is there any way to have a conditional text box? When I click on a text box the conditional formatting option is greyed out. Is there a way around this? In an earlier post I there was a reply but that created a picture and what I'm looking for is a conditionally formatable text box. Help please .... K -- Keyrookie ....
Started 1 day, 11 hours ago (2009-11-25 22:44:00)
by tbrum14
Conditional Formatting Is there a way on Excel 2007 using conditional formatting, for a range of cells to turn red, green, etc... once the same number or character in the range comes up 10, 11, 12 etc... times in a row?
Started 1 day, 11 hours ago (2009-11-25 22:15:00)
by craigwojo
Conditional? If Cell (U3) is greater than "0" then I need row A3:U3 to be yellow. If Cell (U3) is less than "0" then I need row A3:U3 to be green. I am using office 2007. I am quite the novice for putting formulas or whatever in excel and patience is appreciated. Thank you, Craig
Started 1 day, 12 hours ago (2009-11-25 22:06:00)
by Jo-Jo
Please Register to Remove these Ads Hi all, Is it possible to apply conditional formatting to a range (not defined as an actual Range, although it could be if needed) of cells without affecting the formula already in the cells and also so that the conditional formatting formula remains fixed. I've tried using the basic 'fill down' option but that erases the...
Started 1 day, 13 hours ago (2009-11-25 20:24:00)
by ole-123
Hi Im trying to create Conditional Forwarders but when i type in the ip for the server that is authoritative for the domain i get the error "the server with this ip address is not authoritative for the required zone". If i try instead to setup a Stub zone, the authoritative goes fine, so what is the difference ? Regards Ole
Started 1 day, 15 hours ago (2009-11-25 18:30:00)
by Mariner191
Conditional Formatting, Excel 2007 Mr. Excel, How to apply conditional formatting, based on the value of another cell. ex. conditional format for cell A2. If A1> 3, A2 colored green. Thank you, Mariner 191
Started 1 day, 18 hours ago (2009-11-25 15:31:00)
by stan1986
Simple conditional formatting Hello, I'm a novice 2007 excel user. While I assume this must be a simple conditional formatting formula, I don't know how to implement it. I have a row of dates from today to 1/1/2012. I need every 14th day to be highlighted to indicate which days will be payroll days. Since we're paid bimonthly, ...
Started 1 day, 21 hours ago (2009-11-25 12:45:00)
by wicksy1
Conditional Formatting Question I am trying to format a cell to go Green when under 3 mins 30 secs and red anytime over this. In the conditional formatting i have used Formula is =$L$12> 3.5 but this does not seem to work as the cell its reading is also a formaula. Any ideas? Many thanks
Started 1 day, 21 hours ago (2009-11-25 12:30:33)
by awhitefish
I just checked my conditional sell for $1.00 per share and it apparently had expired. So everybody please double check your order status and keep your shares out of the MM's hands. Fish
Started 1 day, 20 hours ago (2009-11-25 14:03:00)
by bjlisu
I have a list with many columns that are Green, Yellow, or Red. I am showing this in a DVWP and wuold like to show the color instead of the text. I can do this, but I have to create 3 different conditional formats for each cell. Is there an easier way? I see a mode selction in the more field box, but there are no instructions on how to use.
Started 1 week ago (2009-11-20 00:33:00)
by hea_admin
Conditional Formatting Formula Hello, I am trying to create a formula in conditional formatting to do the following: If A1 is greater than 0, AND the returned value of B1 is greater than 0, then highlight B1. There is already an IF(SUM... formula in the B1 cell; but I want the conditional formatting to recognize the ...
Started 6 days, 14 hours ago (2009-11-20 19:29:00)
by r_ivica
conditional formatting formula in conditional formatting i have this formula for giving me green cell color: =(B3=large(B3:H3;1)) and this formula means that i want green cell on largest number in range from B3 to H3 and working ok. but now i want to get this formula update better to have only green marked this cells ...
Started 6 days, 16 hours ago (2009-11-20 17:15:00)
by Laavista
Conditional formatting, if not a date How do I enter a conditional format to highlight the cell if it's not a valid date? I tried "formula is": =if(not isdate(C10)) if(isdate(C10)) Your help would be greatly appreciated!!
Started 6 days, 22 hours ago (2009-11-20 11:37:00)
by BenR
Conditional Formatting Formula linked to Cell Hello, Conditional Formatting of both rows B1:F1 and B2:F2 based on the limits within the table below. However.........B2:F2 are number entry cells and from their conditional format, the cells B2:F2 require changing - just the cell colours. A1 B1 C1 D1 E1 F1 ...
Started 4 days, 8 hours ago (2009-11-23 01:52:00)
by Schaw09
Conditional formating Is there a way that anyone knows how to say hide a row in a worksheet with conditional formatting... * Say A8 has the cell red and I want to hide that whole row.. and later cell A9 has a cell that is red and I want that row to hide without recoding? If so I would need a way to view just those as well.....
Started 3 days, 17 hours ago (2009-11-23 16:47:00)
by lmhudson
Complex conditional format I have a range of data that I need to conditional format, but with more than 3 conditions. I understand how to do this using a loop to evaluate the cell and apply a colour Code: Set RangeToFormat = Range("DEFINED_RANGE") - (A1:B5 IN THIS EXAMPLE) For Each cell In RangeToFormat With cell...
Started 3 days, 19 hours ago (2009-11-23 14:54:00)
by karmaimages
Conditional Fomatting Over 2 worksheets Good Afternoon I have an issue with conditional formatting in that excel will not allow it to go over 2 worksheets in a workbook. On one sheet i have a set of questions with Yes or no answers or tick or cross whichever can be entered. On the next sheet i have the list of days ...
Started 3 days, 4 hours ago (2009-11-24 05:50:00)
by wolf735
conditional formatting How do you site up the sheet and/or conditional formatting to alternate colors for different criteria but keep the same formatting for the same criteria. Please assume there is other data that prevents the duplicates from being deleted. this is an example: criteria color formatting ...
Started 2 days, 16 hours ago (2009-11-24 17:19:00)
by RuthRoss
Conditional Formatting with dates Hi, I am trying to use the conditional formatting in Excel 2003. My spreadsheet has dates of when assessments have been undertaken, these need to be reviewed annually so I wish to have an early warning system by making the cells turn a different colour when it reaches a certain period. Red - if ...
Started 2 days, 16 hours ago (2009-11-24 17:35:00)
by jason_1
Quick Conditional formatting Question I have the following conditional formatting on a spreadsheet: Turn Cell Red =COUNTIF(INDIRECT("PSE!$G$14:$K$22"),"r")> 0 Turn Cell Green =COUNTIF(INDIRECT("PSE!$G$14:$K$22"),"r")=0 How do i get some formatting that leaves the cell clear if nothing has been entered at all?
