Conditional Formatting Based on Criteria

[MyCon]

Hi,

I would like to know if it's possible to have conditional formatting based on the following:

Scenario 1 - Every Other Row looking up criteria

For example - This works great.
=MOD(ROW(),2)=0

Now, if I want look up a criteria, such as "XYZ to represent a company's initials, how could I modify the following to get it to work or what would be a good function to use?

=MOD(ROW(),2)="XYZ"
-- This doesn't work for me

Scenario 2

I have 2 rows with several columns. The first couple of columns or rows are merged

Although simple looking, little bit hard to explain format & intent.

Therefore - See attachment

Conditional Formatting Criteria.doc supposed to be Conditional Formatting Criteria.xlsx

Change extension


Thanks

 

[Chihiro]

For the first part...
You need 4 CF.
For example ABC for range C11:I39
=AND(MOD(ROW($C11),2)=0,$C11="ABC")

2nd part...
Don't use Merged cell. Ever. Unless your boss threatens to assign you to latrine duty or worse, if you didn't.

See bobhc's post for some of more compelling reason not to use it.
http://chandoo.org/forum/threads/insert-an-object-shortcut.29437/#post-175956

 

[MyCon]

Hi Chihiro,

I like the, =AND(MOD(ROW($C11),2)=0,$C11="ABC")

That works great!

As for the merge conditional question

I can see if there were calculation issues but a simple highlight 2 rows seems a bit odd despite how powerful Excel is.

I can guess I can go back to my old method & make the cell text the same as the highlighted cell to hide it.

Thanks for the assistance.