conditional formating in adjacent cells

Hi Really hoping someone can help, been up many hours trying to sort this. Basically I want to know how to use conditional formatting for adjacen cells. i.e If cell A1 contains any text then make cell C4 blue the above is just an example and will ...

Message posted on the April 22nd, 2012 - 5:06 AM ET

OpenOffice calc: Conditional formatting

Hash: SHA1 First, I can't find any OpenOpffice or a general Office suite group, so I'm trying here. I want to use a conditional formating rule in Calc, and have found out where to change. Now, my problem is I want to use TEXT and not numbers as ...

Message posted on the February 12th, 2011 - 1:07 PM ET

Color Conditional Formating

Question on conditional formatting, it was sort of resolved in a fe other posts but not fully to what I. I have a restaurant workbook, weekly I input prices between 20 or s vendors. I would like to be able to put the prices in and have what ever ...

Message posted on the January 23rd, 2012 - 12:35 PM ET

Conditional Formating: MAX & MIN

Hello and thanks for reading, I use two conditional format formulas in the same column to bold the highest and lowest values starting in row 6 to row 38 as follows: =(B6=MAX($B$6:$B$38))*(LEN(B6)>0) =(B6=MIN($B$6:$B$38))*(LEN(B6)>0) It ...

Message posted on the April 13th, 2013 - 11:55 PM ET

Conditional Formatting in Excel 2003

Good day everyone, I have an excel sheet to keep track of who has taken a course, when the took it, which automatically calculates ten years from then for th expirtation date. My issue is even the blank cells for people who did not take the cours ...

Message posted on the August 3rd, 2012 - 12:06 PM ET

conditional formating

I am trying to gets cells to turn red if the number in the cell is above 20 but I can get it to work using conditional formating - what am i doing wrong ? or cant it be done that way ? Johnny

Message posted on the January 29th, 2011 - 2:58 PM ET

Conditional Formating based on start and end dates

Hello, I am trying to create a spreadsheet to track the progress of tasks in a project. I found a good example on the web in Open Office and would like to model my spreadsheet off of that example. However, I am new to Excel and can't get past ...

Message posted on the March 31st, 2010 - 8:07 AM ET

named ranges in conditional formating inside a pivottable

Hi (excel 2007) In my pivottable column k show revenue Column l show me the sales responsible. If the revenue is less than e.g. 1,000 I want the name in col I to be red. Using conditional formating I refer to the cell k13 (the upper cell i that ...

Message posted on the February 18th, 2010 - 6:40 AM ET

When does conditional formating fire?

Hi I pull in data via some DDE links and my conditional formating does not change until I modify the sheet in some other way. How can I get conditional formating to fire after an update from my DDE links?

Message posted on the January 20th, 2010 - 11:15 AM ET

Conditional Formating

Hello, I apply conditional formating by using formular to a cell and i want to apply it to all the cell without re-typing the same formular in conditional formating pop up window. I mean i tried to clik and drag to the next cell but it not working ...

Message posted on the July 14th, 2009 - 9:33 PM ET

Conditional Formating

Hi, I need to create either a macro or condition formating so that i can change a field from its defualt to green when a job is done, and back to its defualt when deleted. I've had a go at conditional formating and can change it to green(using a ...

Message posted on the July 3rd, 2009 - 7:00 AM ET

Comparing data sets with +/-1 tolerance using conditional formatin

Please help! This has been puzzling me for hours!! I am using conditional formating to compare one data set with another to see if there are any discrepancies, using green cells for the same and red cells for different data. However, one set of ...

Message posted on the November 25th, 2009 - 10:54 AM ET

Conditional Formating Issue

Okay, I have a problem with a set of conditional formatting. I guess the easy way to explain this is to give the values of cells in question, and the setup of the conditional formatting, so here goes. Cell R2 Value: 500 Cell S2 Value: 1000 Cell T2 ...

Message posted on the December 30th, 2009 - 8:56 PM ET

Count Conditional formating data

I have conditional formating setup on columns A, B, C and D. Depend on result (if value is bigger then 0 cell is green) I would like to calculate (count) in column E number of affected confidional data on columns 1-4. for example A B C ...

Message posted on the November 30th, 2009 - 5:07 AM ET

formating conditional