Conditional Formatting only formats existing data.

It cannot create formulas for you.

You can hide the formulas' results until data is entered.

=IF(A5="","",COUNTIF(B5:M5,"X"))

Drag/copy down column N as far as you wish.

Nothing will show until you have entered data in column A

OR.............you could use event code to copy the formula down each time
you enter a new name in Column A

But why scare users with a macro warning when the above could be a solution.


Gord Dibben MS Excel MVP


On Tue, 17 Mar 2009 12:13:01 -0700, Russ
wrote:

I am building an attendance database using columns A-N. Very standard
Name(A), 12 months(B-M), and a Total(N) columns. I am using a COUNTIF formula
to count X's marked for a month attended.

What I want to do is everytime a new name is added to the sheet(ie A5) the
corresponding total columns(N5) formula =COUNTIF(B5:M5,"X") will appear for
that cell(N5) and so on. Can this be done?