What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"KKD" wrote in message
...
I want to apply my formatting to an entire range. I see there are several
similar questions posted already but I'm not having success with the
answers
provided.

Here is what I am trying to do:

if AC4=W4 then format A4:AC4

I cannot get this formula to apply to my entire range down to row 2000 (If
AC5=W5 then format A5:AC5, and so on)
--
KKD