See attached file On Mon, May 11, 2009 at 8:30 PM, Fabio Lemos <flnle...@gmail.com> wrote:
> If you have to format a list you should remove the anchor ("$") for the
> rows...
>
> Lets say you want to format based on column A and you have many rows.
>
> Select the entyre range and set a conditional format using the formula:
>
> =$A1="Friday"
>
> so, each line will be formated depending of the content of its column A
> cell.
>
> Regards.
>
> 2009/5/11 Dave Bonallack <davebonall...@hotmail.com>
>
>> Hi,
>> If your 'Given Cell' is A1:
>>
>> Select the row you want to format
>> In the Conditional Format window, select 'Formula is'
>> In the formula thingy, put:
>> =$A$1="Friday"
>> Set the formatting you want.
>> Click ok.
>>
>> Hope this helps.
>> Regards - Dave.
>>
>> > Date: Sun, 10 May 2009 19:43:56 -0700
>> > Subject: $$Excel-Macros$$ Condtional Formatting - Query
>> > From: kishore.maro...@gmail.com
>> > To: excel-macros@googlegroups.com
>> >
>> >
>> > Hello,
>> >
>> > I want to use conditional formatting for the below issue:
>> >
>> > eg: If say given cell of a row has value "Friday" then i want that
>> > entire row to be in Blue in color.
>> >
>> > Is the above function possble using conditiona formatting or mix of
>> > standard excel features, wihout using macros
>> >
>> > Thanks
>> > balla
>> >
>> >
>>
>
>
>
> --
> Fabio L Lemos
>
> email: flnle...@gmail.com
>
>
> >
>
--
Thanks & Regards,
Harmeet Singh
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
Book1.xls
Description: MS-Excel spreadsheet
