http://tutorialway.com/conditional-cell-format-in-excel/
visit this website
--
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, accurat
Thanks for reply.
But i can not insert the formula which u have given in french form
can any body do it in attached file & send me back that file ..
On 7 March 2016 at 16:31, Waldan wrote:
> 1) Just add the third restriction in your and(...).
> In French syntax, that's working.
> =ET($F8>=AUJO
1) Just add the third restriction in your and(...).
In French syntax, that's working.
=ET($F8>=AUJOURDHUI();$F8<=AUJOURDHUI()+14;$K8="INF")
2) Don't know
Le dimanche 6 mars 2016 12:47:04 UTC+1, big smile a écrit :
>
> Hello Friends
> In the attached file I want the conditional formating
> bas
please see this site about how to write excel formulas
http://excelautomate.blogspot.in/2013/11/how-to-work-with-formulas-in-excel.html
On Friday, 13 December 2013 05:31:13 UTC+5:30, Troy Nieto wrote:
>
> I want to display in E8 "Complete" if D8 has a strikthrough format in the
> cell, otherwise
for the specified value
>>> highlight the row (in any way you wish)
>>>
>>> but that is not a formula.
>>>
>>>
>>>
>>> *Paul*
>>>
>>> ---------------------
>>> *“Do all the good you can,
>>> By all the means you can,
all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *-
>>
>>
>> --
>> *From:* JohnA
>> *To:* excel
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-------------
>
>
> --
> *From:* JohnA
> *To:* excel-macros@googlegroups.com
> *Sent:* Tue, February 5, 2013 1:56:21 PM
> *Subjec
cros@googlegroups.com
Sent: Tue, February 5, 2013 1:56:21 PM
Subject: $$Excel-Macros$$ Re: Conditional Format Entire Row if Any Column has a
specific value
I wasn't clear enough so I created an example of my question. Thank you all
for
quick responses.
My target value can be in none or
I wasn't clear enough so I created an example of my question. Thank you
all for quick responses.
My target value can be in none or one or many of the 180 columns, not
interdependent on each other, and not in the same column on different
rows. Please see the attached example for a more clear
Hi John,
Please find attached file which has conditional formatting based
on criteria you have mentioned.
Thanks and regards,
Shekhar
On Tuesday, February 5, 2013 8:35:08 PM UTC+5:30, JohnA wrote:
>
> I have a spreadsheet with 180 columns and 8,000 rows. I would like to
> highlight a row i
Hi Shiva,
I guess you need to explain the problem with an example as it is not clear
to us what actually we needs to do.
Regards
prince
On Thursday, January 10, 2013 5:09:20 PM UTC+5:30, shivapr...@gmail.com
wrote:
>
> Dear Champs,
>
> i need one excel formula help tat with conditional format
Combine the cells like so... A1&B1&C1 etc then use COUNTIF
with the coniditional formatting. For example in G2 put
=A2&B2&C2&D2&E2 (you can hide column H). Then for the conditional
formatting start at A2 and use formula =IF(A2<>"",IF(COUNTIF($G:$G,
$G2)>1,TRUE,FALSE))
On Feb 24, 9:35 am, "
12 matches
Mail list logo