>
> http://tutorialway.com/conditional-cell-format-in-excel/
visit this site
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, acc
Hi Liuxin,
Thanks for the encouraging words...!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 8/28/09, liuxin9...@gmail.com wrote:
>
>
> hi,your answer is very good.
> When using the relat
hi,your answer is very good.
When using the relative reference, the first cell in the row gets the
right answer.
However, when it happens in the next cell, the formula changes because
I am using the relative reference.
On Aug 28, 12:35 pm, Dilip Pandey wrote:
> Hi Liuxin,
>
> This is because, wh
Pl. find attached excel sheet for query.
Thanks & Regards,
Dhananjay
On 8/28/09, Dilip Pandey wrote:
>
> Dear Suresh,
>
> Attachment has been solved and re-attached. Thanks.
>
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@ya
Hi Suresh... "The Brave Man"..!!
Thanks a ton..!!
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
2009/8/28 suresh k
> Hi Dilip,
>
> Many thanks for your help.
> I tried without MID formula, even it is workin
Dear Suresh,
Attachment has been solved and re-attached. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 8/27/09, suresh k wrote:
>
> Sorry,
> Now with attachment
>
> On Thu, Aug 27, 2009 at 8:23
Hi Liuxin,
This is because, when you use absolute reference ($ref$), conditional
formatting logics on the entire row is checking if that particular reference
is meeting the logics or not. Moreover, when you apply that logic towards
right direction to cover entire row, the logic still checks only
Hi Dilip,
Can you check this attachment. Its having three options "TRUE", "FALSE" and
"Not available. In this case is it possible to highlight entire rows in
different color based on the result.
On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey wrote:
> Hi Suresh.
>
> Attached file has the scenari
Suresh,
This might help you
http://www.mrexcel.com/hof001.php
Norman
On Thu, Aug 27, 2009 at 7:21 AM, suresh k wrote:
> Hi Guyz,
>
> Whenever we use conditional formatting it will be applied for current cell
> only.
>
> Is there anyway that if the condition is true the entire row should be
> co
I have a question.
When I use the relative reference in the formula, there is only one
cell colored.
While if I use the absolute reference, the complete row is colored,
why?
On 8月27日, 下午10时53分, Dilip Pandey wrote:
> Dear Suresh, I think you forgot to attach the file. Please re-attach and
> sen
Dear Suresh, I think you forgot to attach the file. Please re-attach and
send. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Aug 27, 2009 at 8:17 PM, suresh k wrote:
> Hi Dilip,
>
> Can you
Hi Suresh.
Attached file has the scenario and the explanation for your query. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Aug 27, 2009 at 4:51 PM, suresh k wrote:
> Hi Guyz,
>
> Whenever w
12 matches
Mail list logo
