I need to accomplish several tasks and I am stuck. I am limited to 3

formats so I will list them in order of Importance I know how to do

2,3,4 so if you can tell me how to do #1, I can skip #4 and get this

done.

1. If a row has anything in the first cell, format all the cells in

that row that have anything in them to a pink fill, otherwise leave

them white (no fill)

If I use .......=$A1>"" that will change the entire row 1 to the fill

color that I choose (pink), if there is data in A1. But I only want

B1, F1, and G1 to fill color pink since they have data in them. The

rest are blank. Row 2 will certainly have different cells that have

data.

2. If a cell anywhere has APL it should be red text, yellow fill

3. If a cell anywhere has Holiday in it it should be red text green

fill.

4. If a cell anywhere has HW in it, I want the fill color to be blue.

formats so I will list them in order of Importance I know how to do

2,3,4 so if you can tell me how to do #1, I can skip #4 and get this

done.

1. If a row has anything in the first cell, format all the cells in

that row that have anything in them to a pink fill, otherwise leave

them white (no fill)

If I use .......=$A1>"" that will change the entire row 1 to the fill

color that I choose (pink), if there is data in A1. But I only want

B1, F1, and G1 to fill color pink since they have data in them. The

rest are blank. Row 2 will certainly have different cells that have

data.

2. If a cell anywhere has APL it should be red text, yellow fill

3. If a cell anywhere has Holiday in it it should be red text green

fill.

4. If a cell anywhere has HW in it, I want the fill color to be blue.

- Conditional Formatting: Excel 2003 vs. 2007
- Row Conditional Formatting (Excel 2003)
- Syntax for IF/OR in Conditional Formatting Excel 2003
- Conditional Formating Excel 2003
- Conditional Format - Outline Border
- Conditional Formatting - Excel 2003
- Conditional Formatting - Excel 2003
- 4 or 5 rules on Conditional Formatting (97-2003 Excel)
- Advanced Conditional Formatiing - Excel 2003 - Please Help!
- Conditional Formatting in 2003
- XL 2003: Can conditional formatting go past 4 conditions to N?
- Custom icon set in Conditional Formatting (Excel 2007)?
- Conditional Formatting for more than 4 conditions in Excel 2003 based on external cells
- COUNTIF with multiple conditions in Excel 2003
- Excel Conditional Formatting More than 3.
- Conditional formatting Excel 2007 Color Scales for Text
- Conditional Formatting Excel 2011 - fill colour SHOULD be blank, but shows up as white! help!
- Basis of Icon Set (conditional formatting) Excel 2007
- Conditional Formatting/Excel Version Problem
- Conditional formatting.... Excel 2002
- Copy & Pasting Conditional Formats (Excel 07)
- Excel 2003, It wont print in landscape format
- Conditional Formatting excel 2007
- how to create a counter based on an IF condition in Excel 2003
- Solid conditional formatting Excel

Formatting criteria. Does Excel 2007? Thank you, JP.

In previous attempts my formatting only applied to the current cell once I entered values in the Game 2 and 3 columns.

I realize this is an Excel 2007 file, but the actual file will be managed via Excel 2003.

I would be most grateful if anyone could assist me on the correct syntax for an IF/OR statement in Conditional Formatting in Excel 2003.

What I am trying to check for is:-

If E11 >= C11 OR if E22 <= D11 then colour the cell yellow

Any assistance would be greatly appreciated

Many thanks in advance

Rob

http://www.mrexcel.com/forum/showthr...itional+format

Asks almost exactly the question I have, but I can't make heads or tails out of the answers, I'm guessing becasue I have Excel 2003 and not 2007 as mentioned in the replies.

Anyway, here's my question:

In column "A" I have a number; column "B" the formula =A1 copied on down and in column "C" either a 1 or 2 or a 3.

If the number in column "C" is a 1 then the font in the same cell in Column "B" should be black, 2 Blue and 3 Red.

I'm thinking this should be very simple, but so far it's not turning out that way. )-:

.

.

.

.

.

I would like to use Conditional Formatting (Excel 2003 Windows) to put a

Border around two cells in the same column. The second cell to be formatted

will always be directly beneath the first cell; i.e. cell I2 (1st) and I3

(2nd).

There are two consecutive rows for each Numeric Label - the Rank is the 1st

row and the Frequency the 2nd row. The Rank is listed twice in column "B" for

each Numeric Label for sorting purposes.

Each Rank in a row is unique.

The criteria to Conditionally Format the cells - Format Rank and related

Frequency:

1. Match Rank >=10 (greater than or equal to 10) in the 1st row of the

relevant Numeric Label - CF is a Border. The Ranks to be matched may be in

any column between "E" and "I".

2. Put a Border around the cell in the 2nd row (Frequency) that corresponds

to the Numeric Label and is directly below the Matched Rank in the 1st row.

Sample Data Layout:

Columns: "A" = Numeric Label, "B" = Rank, "C" = Total, "D" = Text Labels, "E":

"I" = Rank & Frequency (6th-10th Position). The Data starts on row 2 with

Numeric Label 220. Data row 2 to 11.

Label Rank Total POS 6th 7th 8th 9th 10th

220 18 Total Rank 14 10 17 12 18

220 18 1041 Freq 7 6 5 3 3

470 16 Total Rank 6 15 13 17 11

470 16 1058 Freq 4 4 3 3 2

180 14 Total Rank 13 10 16 12 14

180 14 1042 Freq 6 5 4 3 3

400 13 Total Rank 11 14 5 23 13

400 13 1053 Freq 5 5 4 4 3

40 11 Total Rank 9 11 13 15 14

40 11 1040 Freq 6 5 4 4 3

Expected Results:

Label 220 - Row2 Column "I" Rank 18 & Row3 Frequency 3 should have an outline

Border.

Label 180 - Row6 Column "I" Rank 14 & Row7 Frequency 3 should have an outline

Border.

Label 400 - Row8 Column "I" Rank 13 & Row9 Frequency 3 should have an outline

Border.

Label 40 - Row10 Column "F" Rank 11 & Row11 Frequency 5 should have an

outline Border.

Thanks

Sam

--

Message posted via http://www.officekb.com

zeros?

For example, I have a department number of 00123 and would like to highlight

all instances of this number. When entering directly in to the dialog box,

the zeros are dropped.

Any ideas how to do the following using conditional formatting (or is it even possible?) -

I have a range of values from 0 - 100

I want to use conditional formatting to make :

values that equal 0, cells turn the colour green

values that are between 1 and 99, cells turn the colour amber

values that are greater than 100, cells turn the colour red

For examle : -

Condition 1 Formula Is = A2 = 0

Condition 2 Formula Is = IF(AND(A2>0,A2<100)

Condition 3 Formula Is = A2 > 100

Hope the above makes sense - any suggestions would be appreciated!!

I've made a spreadsheet at home on Excel 2007 which has up to 5 Conditional Formatting rules per cell which works fine. The problem is when I save as 97-2003 version to send to work, the old version of Excel only supports 3 rules as you know, is there a way of applying 4 or 5 rules when specific text is populated in a cell on the old version of Excel?

Many thanks

It's pretty hard to put into words as an example so I have uploaded my spreadhseet here: http://rapidshare.com/files/149674609/Book1.xls

Basically I have a couple of lookup functions that get data from the 'Data' sheet. The look up is searching based on the data in cell B4.

This then returns the results in Cells B13:B16. Cells D13:D16 I have some conditional formatting rules.

I want certain cells to appear with data and displayed with conditonal formatting based on the selection from a drop down list.

For example:

I have conditional formating on B13 so it appears blank until a selection is made in Cell B4. Then depending on what data is chosen in B4 different information will be displayed in cells B13:B16 and different formating in D13:D16.

Conditional Formating on B13 is:

Cell Value = 0 (Format - white text with no borders)

=ISERROR(B13) (Format - white text with no borders)

Conditional formating on D16 is:

=ISERROR(B13) (Format - white text with no borders)

=NOT(ISBLANK(B13)) (Format - black text with a black border)

The Scenario:

Cell B3 contains the Text "New_User" (selected from a drop down list)

Cell B3 contains the Text "Sales" (selected from a drop down list)

Cell B4 contains the Text "BS" (selected from a drop down list)

The lookup function in B13: =LOOKUP(B4,Data!A12:B15)

This would return "Sales Rep Postal Codes:" in Cell B13. B16 should then use conditional formating to place a black border around the cell with black text.

This all works fine. However, if the selection made from the drop down list in B4 is "T" then this returns a value of "0" in B13, as a result the conditional formating on B16 is black border and black text when i want it to be no border with white text.

If the selection in B4 is "BS" or "O" then I want cell B16 to have black border and black text. If no selection has been made in B4 or if "T" is selected then I want B16 to have no border with white text.

I hope somone understands what I'm saying and can help me!! I have tried everything I can think of to get it to display teh way I want.

I have uplaoded the spreadhseet on the link above because it will probably be easier for you to understand what I'm trying to do if you look at the spreadhseet, I tried to use the HTML maker but it doesn't display correctly.

Please help! Thanks in advance!

John

Since in Excel 2003 there are only three options for conditional formatting. I used two for green (A1 greater than B1) and yellow (formulas in A1 equals AND(A1<B1, A1>=B1*0.75)). I want to set A1 to red when its value <B1*0.75 or is “DataNAvail”. Since they are not the same type, I don’t know how to do it. Could anyone give me a help? Thank you.

Frank

I have been asked to colour code a row within Excel 2003 based on a number between 1 and 9 in the first column.

Can you have more then 4 conditions in Excel 2003 i.e.

A1 = 1, cell is red

A1 = 2, cell is green

.

.

A1 = 9, cell is 9th different colour

If this is possible, can you conditionally format a range within the row i.e.

A1 = 1, then A1:A10 are red

A1 = 2, then A1:A10 are green

Hope you can help.

Chris

thanks in advance.

Tom Brady plays for the New England Patriots. His background color would be value 1, and his text color would be value 2. The team name is in cell B2, and cells A1:C2 need to be colored the same as B2. I understand that this will most likely involve a macro (which I don't understand because I haven't learned the Visual Basic language yet). Any ideas?

Thanks

I have two columns of numbers, and I want to count the number of entries that have the value "0" in NEITHER column.

I am using Excel 2003, which doesn't have the COUNTIFS function that allows you to directly supply multiple conditions. In Excel 2007 I would input this as

=COUNTIFS(A1:A10, ">0", B1:B10, ">0") since all values are positive.

Any insight?

Thank you very much.

Thanks in advance to all those who answer.

Before i ask what i need to know i will clarify some things i already know to help out those who answer.

1. I know that you can conditionally format Excel to change the background color if it meets a value.

2. I know that you can change the formatting of a cell in column A based on a value in Column B.

3. I know that you can only set 3 conditions in Excel 2002.

4. I know you can set unlimited conditions in Excel 2007. (i dont want to get 2007)

5. I know that you can use VBA code and apply it in excel 2002 in order to create more conditions.

MY QUESTION IS:how can i get VBA code that can add conditions (more than 3 per column) to a work sheet that allows conditioning of cells in Row B based on values of Cells in Row A.

If you could supply a VBA code that i could copy that would be great.

I am also open to purchasing an excel plug in for 2002 that allows unlimited format conditions.

And an open to any other suggestions you may have.

Thanks for your help.

I'm trying to use Excel 2007's Conditional formatting color scales, but I would like to have the numbers within the cells 'disappear' or match the color of the background. Any advice would be appreciated!

Cheers,

Eric

Conditional formatting has been added to all these drop down cells, so that if customer is selected, the font turns "orange", and if client is selected, the font turns "blue". I have set the Background/fill in conditional formatting to "no colour/no fill".

my problem is that it doesn't make the background "No fill" - but in fact white! no matter what i do!

when an actual selection is made (either customer or client), the font changes colour as it should, but background colour changes to white, even though it should still remain grey (or dark grey) considering i set the background to "no fill/no colour"!

for my original fills that are set to white, then isn't a problem - but for my grey cells, it is.

i understand that I could individually set the background of the grey cells to the same colour in conditional formatting to match it, but that is time consuming - and namely; i shouldn't have to, as i have set the background transparent by selecting "no fill".

argh so frustrating!

seems to be an excel bug to me.

anyone else had this problem? help!

which you can assign an icon on a particular value or range of values. i just

what to know how does the default condition of icon set work? by default,

excel is using the 67% and 33% for 3 iconset but i want to know 67% of what

or 33% of what? how did they compute for that? how did they get it or how did

they compute it? i tried several ways of computing it using the 67% and 33%

but still it doesnt fit the default conditional formatting for icon set. is

it the 67% or 33% of the total of the range or what? im really confused. i

really need to know the answer coz for sure my students will ask me about it.

hope someone can help me about this...

thanks! ^_^

I created a conditional format formula with ver 97 that hightlights duplicates:

=COUNTIF($A$3:$AX$1003,A3)>1

It works fine in 97, but when users use a newer Excel, it only works at an extreme snails pace (many seconds later even when trying to enter new data on the sheet).

Any advise would really help.

Bob

In Conditional formatting I am only permitted upto 3 Conditions but I

have 6 conditions how may I overcome.

Do later Excel revisions allow for more conditions in Conditional

fromatting?

Thanks

Gunjani

Firstly, I'll give an image example of my worksheet:

http://i29.tinypic.com/s2u0p0.jpg

The cell that is coloured with a red fill has three conditional statments in it, which are:

If highlighted cell value is greater than C2 then fill is green

If highlighted cell value is less than C2 then fill is red

If highlighted cell value is equal to C2 then fill is blank

So basically if "6" in this case is lower than "9" then fill the cell red, which it has done. But how do I copy this conditional format to all the other cells, ie: D2, F3, H2, B2, D3 and so forth (the first number of every group on every row)... when I tried to copy + paste the cell to another one I thought that Excel would automatically change the value itself of the number it was look at, but it doesn't and I copy it, it looks like this:

http://i26.tinypic.com/a3h9jb.jpg

Which is wrong because each of the copied cells is still using C2 for it's original value, instead of the value of the cell to the right of it, so looking like this would be correct (I just manually coloured all the cells for the example):

http://i27.tinypic.com/eqxyps.jpg

Is there an easy way to do this, or do I have to manually create hree conditional format rules for every single cell? (which would be very harsh, because the screenshots are just examples and the proper workbook has hundreds of columns)

Cheers!

However, Excel runs Ok, but I have noticed that it will not view or print in

Landscape format. Even if you have a previous saved document from excel 2002

in landscape format, Excel 2003 will not show this document in Landscape mode.

Can somebody assist..?

I am new to this forum. This is what I am struggling with.

Attached is an excel sheet with an example of what I am trying to do.

If value in column A is not equal to the value in Column B, then either Column B or Column C should get the color Red. Can I do by using a formula in Conditional Formatting?

I tried using IF statement but dont know how to pick a color in the formula. I am a newbie, so please help me.

Hopefully someone can shed some light on this problem I have:

If the value in cell A1 is 1, I would like cells B1 to L1 (the next 11 cells) to also display the value 1 and also for the cells A1 to L1 to turn green.

On the other hand if the value in cell A1 is 0 or nothing, then cells B1 to L1 will either display 0 or nothing corresponding to what the value is in cell A1 (0 or nothing). In addition, I would like the cells A1 to L1 in this case turn red.

However, I need this done for each cell in a row, For example: for any cell in a worksheet row I enter 1 in, I want the next 11 cells to automatically display 1, and to have the other conditions I wrote above.

Also what is important is that though; for example: cell A1 and B1 must have the same conditions, If i was to entre the value 1 in cell A1 the next 11 cells must display 1, but now that cell B1 has value of 1, I dont want the next 11 cells from cell B1 to display 1. The solution must recognise which cell has 1 entered into it and only the next 11 cells must automatically display 1.

Is this possible to do in Excel 2003,

Any help on this subject would be greatly appreciated!

I.e

cell A1:100,000

A2:35%

A3:65%

A4:Conditional formatting to highlight distribution

On the conditional formatting I can only find a graded scale but need the bar to be a solid fill with clear definition of the two values ideally with a midpoint bar.

Any help on this matter is greatly appreciated.

Regards,

Mark

No luck finding an answer? You could always try Google.