Microsoft Excel - CONDITIONAL FORMATTING - Asked By CT on 14-Mar-12 10:23 AM

Earn up to 50 extra points for answering this tough question.
Hi -

I would like to draw a line across from column A through Z every time the text information in column U changed.

Example:

U1: EAST
U2: EAST
U3: EAST
U4: SOUTH
U5: SOUTH
U6: SOUTH
U7: WEST
U8: WEST

Draw  the line from A3 through Z3, A6 through Z6 and from A8 through Z8.

Help Please!

Thanks,

CT
Web Star replied to CT on 14-Mar-12 12:26 PM
See these link to show how can you put conditional formatting in excel with details help of example
http://www.contextures.com/xlcondformat03.html
http://www.contextures.com/xlcondFormat01.html
http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel
hope this helps you
Parag Satpute replied to CT on 14-Mar-12 01:06 PM
Do you type manually in Column "U" or is it changed through a formula??
CT replied to Parag Satpute on 14-Mar-12 01:16 PM
Yes, I type manually in Column "U".

Thanks,
CT
CT replied to Web Star on 14-Mar-12 02:35 PM
Thanks so much for your help Web Star! I got it worked!!!!!
Somesh Yadav replied to CT on 15-Mar-12 01:09 AM
Hi refer to the below link,
some sample examples are explained here,

http://www.contextures.com/xlcondformat03.html

hope it helps you.
Reena Jain replied to CT on 15-Mar-12 03:32 AM
hi,

--Select the range (say A1:A10) . Make sure cell A1 referred in the formula is the active cell in the selection.

--Apply the below conditional formatting formula and select the desired formatting..
=--(SUMPRODUCT(--(EXACT($A$1:A1,A1))))>1

try this also