I have data in Excel like below, i want to display two things here -

-

I have data in excel as below, i want to display two things here

1) If the urea column H = - then the column B should change the color.

2) If MR + VP should come in its own form - 

 SLNo SID RV TT BSA XLD Lact Urea TSI Industries MR VP Seat Nitrate Oxidated ONPG PCR Salam? SB H2S GR 1 R-13 + KA - - + - + - + - - - 2 - 5 TB - KK - - + + + + + - - 3 7.3 R + KA - - + + + + + - - - 4 11.1 R + KA + - + - + - + - - 5 + 15 + KA - + + + + - + - - 6 16.2 RB - K + + + + + - D - - 7 18.04 - KK - - + - + - + - - - 8 18.1 RKK - - + - - - + + - - - 9 20.2 RKA - + + + + + + - - + 10 20.3 T - KA - - + + + + + - - + + 11R / 28.1-K + + + + - - - - + +

ans1:

I have used conditional formatting option and = ISNUMBER (SEARCH (H5, "-")), it works, but the problem is also empty in the urea column

ans 2: Pls suggest

Answer 1: Your CF formula is wrong. Find_Text is the first argument;

Or, simple 

  code> = H2 = "-"

Answer 2 : You can use an event-triggered macro to enter this event-triggered macro, right-click on the sheet tab. Select "View Code" from the right-click drop-down menu and then paste the code below into the window that opens. 

  Options Clear private sub worksheet tags (by-target in range form), in the form of dim RRR range, cell set as range in the form of RVP range Range = RR = with After address (what: = "MR", after: = [A1], Lookin: = XLVL, letterat: = XLHhohl, _Searchender: = XLBIRIO, Search Decrease: = XL-NX, MatchCyz: = False) RVP = Set Please. (What is: = "VP") If RMR is nothing and RVP is nothing then set RMR = range (RMR, cells (rows.count, RMR column). End (XLEEP) set RVP = RVP Reset (Rows: = RMR.ROS.Count)  Application. Enabled Events = Untrue If there is no difference (Target, RMR) then there is no built in Target (Target, RMR) for each C C. Value = "+" then RVP (CRRO). If value is not something (target, RVP) is nothing, then for each C, the RMR (CR) value for intersecting (target, RVP) value = "+" then value = "+" then value of C. = value = "-" Next C & End If If Applied Cation.EnableEvents = True End Sub

Comments

Post a Comment

Popular posts from this blog

import - Python ImportError: No module named wmi -

-
I followed the instructions for downloading WMI for Python When I try to run the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = wmi.WMI (): if Raw_input ("restart% s?"% S.Caption) .upper () == "Y": s.StartService () I got the error < Code> traceback (most recent call end): file ". \", Line 1, edit: I am using Python 2.7.6 EDIT2: I am running 64-bit Windows 2008 R2, and I've downloaded WMI-1.4.9.zip (md5). I removed the content and put it in D: Python \ Tools \ Scripts I executed dragon setup.py.install I said D : \ Python \ tools \ scripts to% PATH% and when I execute the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = Wmi.WMI (): If raw_input ("Restart% s?"% S. Caption). () == "Y": s.StartService () error me Gets traceback (most recent call final): File ". See \", line 1, &
Read more

Editing Python Class in Shell and SQLAlchemy -

-
I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla
Read more

c# - MySQL Parameterized Select Query joining tables issue -

-
I am using parameterized select questions in conjunction with my program and it works entirely, When I try to join the table Everything I have done is a small fraction: using (MySqlCommand cmd = new MySqlCommand (paramQuery) ToSql (), Connection)) /etc/ paramQuery.ToSql () Equal: "Select TableOne ID, Tableon, Department, Tablet. One by name table, Table 2 h Yes TableOnEID = @Pharmak "* / for (Int Index = 0; Index and Lt; ParamariX Parameter (.c calculation; Index ++) Cmd.Parameters.AddWithValue (paramQuery.Parameters (). ElementAt (index). , ParamQuery.Parameters (). ElementAt (index) .Value); / * ParamQuery.Parameters (). ElementAt (index) .k = "@most 0" paramQuery.Parameters (). ElementAt (index) .Value = "tableTwo.ID" * / MySqlDataReader Reader = cmd.ExecuteReader (); While (reader.Read ()) {// do stuff} } One of the tables I attempt to join is For the table, two with the same id for all. Is there something that I'm doing wrong?
Read more