<div>
Depending on you excel version you can do it via menu bar. following link should help in understanding the different condition you can use conditional formatting.<br />
<br />
<br />
<a href="http://www.contextures.com/xlcondformat03.html" rel="ugc">http://www.contextures.com/xlcondformat03.html</a>
</div>


Depending on you excel version you can do it via menu bar. following link should help in understanding the different condition you can use conditional formatting.


http://www.contextures.com/xlcondformat03.html [http://www.contextures.com/xlcondformat03.html]

<div>
Hi,<br />
<br />
Thanks for the link netballi, it has nice conditional format samples... But I still &nbsp;have no idea on how the formula that I need should be ?.<br />
<br />
Regards,<br />
Roberto.
</div>


Hi,

Thanks for the link netballi, it has nice conditional format samples... But I still  have no idea on how the formula that I need should be ?.

Regards,
Roberto.

Book1.xlsx

<div>
Dear Teylyn,<br />
I wish that God Blesses each neuron and synapse of your brain.<br />
The formula is just as need it.<br />
Thank you VERY much !!.<br />
Roberto.
</div>


Dear Teylyn,
I wish that God Blesses each neuron and synapse of your brain.
The formula is just as need it.
Thank you VERY much !!.
Roberto.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
In column &quot;E&quot; I need to add a Conditional Format Formula that higlight the cell in red when the value format typed is NOT as need it.<br />
<br />
The values un column &quot;E&quot; must be like this: &nbsp;J-31473021-5<br />
(Letter &quot;J&quot; or &quot;G&quot; followed by &quot;-&quot; then 8 numbers then &quot;-&quot; and finally 1 number).<br />
<br />
¿There is a way to do it ?<br />
<br />
Thank you in advance for your help.<br />
<br />
Regards,<br />
Roberto.
</div>
</div>


Hi,

In column "E" I need to add a Conditional Format Formula that higlight the cell in red when the value format typed is NOT as need it.

The values un column "E" must be like this:  J-31473021-5
(Letter "J" or "G" followed by "-" then 8 numbers then "-" and finally 1 number).

¿There is a way to do it ?

Thank you in advance for your help.

Regards,
Roberto.

CONDITIONAL FORMAT FORMULA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.