Conditional Formatting based on rule

**lilit2222** · 07-22-2020, 01:43 AM

I have an excel file with two columns. Column 1- Account Number and Column 2- Account holder.

I want to write a rule such that if cell in Column 2 is equal to "Armen" and adjacent cell in Column 1 starts with "CY", then the the cell in Column 2 will be highlighted.

We can do this with vba as well.

Is this possible.?

See attached the sample file

**JieJenn** · 07-22-2020, 02:16 AM

Highlight the cells in column B, then use this formula to set the rule to in the conditional formatting.
=AND(left($A2,2)="CY", $B2="Armen")

Conditional Formatting based on rule

LinkBack

Thread Tools

Rate This Thread

Display

Conditional Formatting based on rule

Re: Conditional Formatting based on rule

Thread Information

Users Browsing this Thread

Similar Threads

Change cell value based on conditional formatting rule being met

Conditional Formatting - % based off a rule

[SOLVED] Conditional Formatting based on Calculation w/ in rule.

[SOLVED] Conditional formatting rule - based on values in a table

Conditional Formatting-New Rule based on icon sets according to value(%) does not execute

[SOLVED] A conditional formatting rule that will highlight a cell based on certain criteria/date

Conditional formatting based on a rule

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions