Hide or Show Worksheet Tabs in Excel

Option 1: Using advance option in the Microsoft Excel

File Menu à Options à Advanced à Scroll down à Display options for this workbook: 

þ Show Sheet Tabs à to show sheet tabs

¨ Show Sheet Tabs à to hide all sheet tabs

Note: When you hide all sheet tabs you are unable to move to other sheets in the workbook. So you need to create links to other sheets before hiding all sheets.

Hide or Show Worksheet Tabs, Excel 2007, Excel 2010, Advanced Excel, 

Option 2: Using Visual Basic Application (VBA)

File Menu à Options à Customize Ribbon à Tick þ Developer à OK 

VBA

à Insert à Module à Double click on Module and then copy and paste code below.

Conditional Formatting based on Another Cell

You can use Conditional format based on another cell containing part of text or value.

a.      Conditional Format based on Value

If we want to highlight the lower or higher number, we can use the formula below.

Select Cells => Home=> Conditional Formatting => New Rule… =>

=> Format…=> select format you like => OK

If the column B with number and text and we want to highlight value number, we can use formula below:

Formula: ISNUMBER($B2)

b.      Conditional Format based on Text

The conditional formatting will apply only on text.

·         Select Cells => Home=> Conditional Formatting => New Rule… =>

Formula: ISTEXT($B2)

c.      Conditional Format based on Specific Text

If you want to highlight cells based on specific text, you need to use the formula below:

Formula: =ISNUMBER(SEARCH("Yes",$B2))=TRUE

If you have any update or other found formula, please share or comment below.

How to Fix Packages in Cydia not loading on iOS 7.0.4

How to Fix Packages in Cydia not loading on iOS 7.0.4 on iPhone 5

After jailbreaking iPhone 5 to iOS 7.0.4, the cydia requested to update some elements below:

1. - Cydia Substrate 
2. - Evasi0n7.x Untether
3. - New Curses
4. - Substrate Safe Mode

I have updated them all as I hope it might be better, but unfortunately when I closed the cydia and started it again, it didn't work. The message below:

- Wow, you exceeded the number of package names this APT is capable of.

- Problem with MergeList

   /var/lib/apt/lists/apt.modmyi.com_dists_stable_main_binary-iphoneos-arm_Packages

- The package lists or status file could not be parsed or opened.

When click on the Section, Changes, or Packages, everything inside disappeared.

Please tell me how to solve it.