Conditional Formatting

[Russ]

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?

 

[Gord Dibben]

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

 

[Russ]

Thanks Gord the formula you provided is what I was looking for.