Microsoft Excel - CONDITIONAL FORMATTING
Asked By CT on 14-Mar-12 10:23 AM
I would like to draw a line across from column A through Z every time the text information in column U changed.
Draw the line from A3 through Z3, A6 through Z6 and from A8 through Z8.
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
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".
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,
hope it helps you.
Reena Jain replied to CT on 15-Mar-12 03:32 AM
--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..
try this also