#condition formatting

'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...

All Question And Answer to save in "Sheet1) We Need Reference "Question" Sheet1 to Sheet 2 , Also need four Option reference data from Sheet 1 According Question Kindly make solution this query

How to Highlight RAW After Bold Text ??? "E2" cell text is bold after Highlight raw on red color with white font & bold also

This Formula use , Missing Date find perfect , but we need Find "Bill Number " , Because my file Large Amount of Bill Numbers ( May be 3000 Bill Number ) =SMALL(IF(ISERROR(MATCH($E$2+ROW(OFFSET($B$2,0,0,$E$3-$E$2+1))-2,$B$3:$B$7,0)),$E$2+ROW(OFFSET($B$2,0,0,$E$3-$E$2+1))-2),ROW(A1)) ( This...

How to Filter Both Pivot-table Data According After Select Drop-Downlist. "i Try select party name on drop-downlist , After filter both pivotable data on working with drop-downlist (WE NEED MULTIPLE PIVOTABLE AFTER SELECT DROP-DOWNLIST

I Need Hyphen " - " Symbol via Formula, Unique Number based Condition , Found Duplicate & set Hyphen Symbol - in D Coloumn

Between two Slashs "/" Or Two and more Slashs how to work formula in this condition

@ HOW TO LOCK COLUMNS ??? I try Column " A" & "B" FIX & Lock ....... This "HSN CODE " IS EVERY TIME FIX & SAME IN BILL ......... Problem : 5 and more people use this File, So my was Change every time , i tried ... We Need lock Columns lock trick .. pleased solve my Query.

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

I was try , 3 table marge but i was tried ...... i was remove this table , & make New table but this last Name Assign Problem ...... How make Running File Marge 3 table , Without loss Data...??? How to possible ??? Pleased Show me Step- by- Step.