hot to draw FontBold When Error on cell

jamiguel77

Active Member
Joined
Feb 14, 2006
Messages
378
Office Version
  1. 2016
  2. 2010
  3. 2007
Platform
  1. Windows
  2. Web
hi all, on I4 exist a Error, right?
how to drwa Font Bold on cell (same row), C4

Libro2
ABCDEFGHIJK
1PEDIMENTO IMPFECHAMATERIALCANTIDADVALOR ADUANA USDFACTIMPEmpresa
219 67 3435 90015289001528900152807-ene-19ARNES DE USO AUTOMOTRIZ885053,809.19LCCH-0043MINGHUA8004456BMW
319 67 3435 90015299001529900152907-ene-19ARNES DE USO AUTOMOTRIZ21600325,520.66LCCH-0042VW8004456BMW
419 67 3435 90016629001662900166208-ene-19ARNES DE USO AUTOMOTRIZ1122069,417.58LCCH-0046#N/D8004456BMW
519 67 3435 90016639001663900166308-ene-19ARNES DE USO AUTOMOTRIZ238481,695,841.32LCH-0047BMW8004456BMW
619 67 3435 90016649001664900166408-ene-19ARNES DE USO AUTOMOTRIZ31680353,358.25LCCH-0045#N/D8004456BMW
719 67 3435 90047319004731900473110-ene-19ARNES DE USO AUTOMOTRIZ20942129,651.08LCCH-0052#N/D8004456BMW
819 67 3435 90047329004732900473210-ene-19ARNES DE USO AUTOMOTRIZ25984318,800.68LCCH-0051VW8004456BMW
919 67 3435 90015239001523900152311-ene-19ARNES DE USO AUTOMOTRIZ203141,338,573.53LCCH-0054BMW8004456BMW
1019 67 3435 90015239001523900152311-ene-19ARNES DE USO AUTOMOTRIZ10455688,923.22LCCH-0054BMW8004456BMW
Hoja1
Cell Formulas
RangeFormula
B2:B10B2=RIGHT(A2,7)
C2:C10C2=B2*1
I3:I10I3=VLOOKUP(C3,$J$2:$K$1430,2, FALSE)


thanks
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
You can do it with conditional formatting
1712856149275.png
 
Upvote 0
Solution

Forum statistics

Threads
1,215,360
Messages
6,124,491
Members
449,166
Latest member
hokjock

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top