Conditional Format-apply to every row

**hassankhan** · 08-13-2009, 12:28 AM

The format code is

Please Login or Register  to view this content.

I just need this to apply to every row from a12:f12 to a:512 to f512. I cant drag format since it needs to apply to individual row

**shg** · 08-13-2009, 12:43 AM

It's a little hard to guess what you're trying to do. Maybe this:

Please Login or Register  to view this content.

**hassankhan** · 08-13-2009, 12:56 AM

I select a12:f12

Conditional Format

Formula

if a6=e12 then highlight row

that formula need to applied to every row until a512:f512

**hassankhan** · 08-13-2009, 03:24 AM

Please help

re: Conditional Format-apply to every row