Excel: Can I do this with Conditional Formatting?

Hmm_Messiah

Hi

I have a wooksheet detailling dates, case type, case quantity, casse rate, volumes, and value(euro) etc

I have 2 case tyoes abd selected that column so if typeA format changes -bold, shaded , different colour
.

What i am trying to find out is can I extend the formats so the relevant whole row will shade and change colour etc ?

Have tried Excel Help - but not working (or I'm rerading it wrong)

have also tried paste special to copy the formats but thats doing weird things - resizing all the columns etc

thanks

Tom Dunne

I don't understand what you are trying to say - could you clarify that a bit more?

prospect

To apply Conditional Formatting to an entire row in one swoop just click the Column Letter at the top of the sheet. This will select the entire column, and you can apply your conditions in the same way you would to a single cell.

Is that what you want to know?

Hmm_Messiah

Sorry , I'll try again ;

I have data in a column with conditional formatting eg "DIRECT" or "OTHER"
so if the deliveries are "direct" its one set of prices , if "other" a different set

Have IF functions creating the formulas and thats fine.

now this column which contains either "direct" or "other" as text is conditionally formatted so direct appears italic bold and shaded. - so i can see a general trend with out sorting and filtering.

What I want to know is with only conditional formatting relevant in that one column can I apply the formatting across rows - so not only the cell containing direct appears highlighted etc but the who row:


12.01.01 other 125cs 2.00 250.00
14.01.01 other 125cs 2.00 250.00
22.01.01 direct 125cs 1.00 125.00
18.01.01 other 25cs 2.00 50.00
24.01.01 other 100cs 2.00 200.00

xebec

This tutorial might help.

Basically you'll have to select the whole sheet and then put the conditional formatting in depending on the cells with Direct or Other in them. (I think)

prospect

I understand what you are trying to do now. I haven't come across it before, but leave it with me for a while.

Edit:

Okay, here it is.
Highlight all of your table.
Select the Conditional Formatting option.
In the first box of the Conditional Formatting window, use the drop down arrow to change the option too "Formula Is"
*In this example, your first row in the table is row '3' and the column with your Delivery details is column 'C'
In the Formula box type: =$C3="Direct" -Include both equals signs, the dollar sign and the inverted commas.
Then in the format box choose the format you like.

that should do it.

Edit No2. Formula was wrong.

Hmm_Messiah

cheers - thanks alot


that worked but I had to select the column c rather than just cell c3

I've attached the file incase the idea is useful to any one