Hi Balla,
Please find the solution attached.
Explanation:-
Select the entire row 1 and apply conditional formatting choosig Formula:-
=ISNUMBER(MATCH("*Friday*",1:1,0))
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
See attached file
On Mon, May 11, 2009 at 8:30 PM, Fabio Lemos 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 f
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
this article might help
Ref: http://www.contextures.com/xlCondFormat02.html
freddy
> 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 conditiona
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
> Sub
