Follow Us on Facebook

Khmer Dictionaries

Follow us on Twitter


Search More Information

Wednesday, March 5, 2014

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.


Post a Comment

Like Me on Facebook

Donation by PayPal

Blog Archive