Conditional Formatting

[Stanley]

Is there a way to apply a conditional format to a row if
a specific cell in that row meets a set criteria i.e if a
cell in the row is equal to "0" then the font is changed
to red for all fields in the row?

Thank you,

 

[J.E. McGimpsey]

Just out of curiosity, when is it difficult or unsafe to copy
formatting, including CF? Certainly, if it's known in advance that
there will be more than one row (in this case the OP didn't indicate
that) preselecting all of them may save a couple of keystrokes. I've
never had a problem with copying formats, though. And in this
particular instance, formatting one row eliminates any potential
problems with keeping track of the active cell. Again, not
disputing, but curious.

 

[David McRitchie]

If you already have data in the additional rows, if you fill-down
or copy the cells you also copy and paste the values.

Or should I say unsafe for me, because you probably use
the Copy(ctrl+C), Edit, Paste Special, Formulas
or use the Format Painter Tool. avoiding the problem
altogether.

I like to format entire columns or the entire page ahead
of time. Then I fewer problems with what is formatted
and what is not formatted with C.F..

I created a macro a few days ago and fixed it up today
involving Paste Special Formats, which I found interesting,
can be seen at
http://www.mvps.org/dmcritchie/excel/paste.htm#painter

 

[J.E. McGimpsey]

Actually, I have XL's Paste Formatting command assigned to a key
combo, so I never have to use the menus. But I see what you were
getting at.

I also like to format columns/pages ahead of time when I'm
designing. My experience, however, is that most people format on the
fly (hence the number of "too many formats" questions). Planning
ahead is something that usually comes only after tearing one's hair
out while having to rework major projects on a deadline. Layouts
always seem intuitively obvious until they're 80% done and the
client want "just a tiny little change".

I'll take a look at the Macro - thanks David!