Or...how can i prevent that the other cells are filled


"Gord Dibben" wrote:

Conditional FormattingFormula is:

=COUNTIF($A$1:$C$1,"J")=1

Edit the error message to suit.


Gord Dibben MS Excel MVP

On Thu, 9 Jul 2009 06:36:01 -0700, Peter Jonkers
wrote:

I have 3 cells called "overtime" Traveltime"and "Servicetime"
Those cells are in a single row.
I am looking for a way so that only ONE of those cells are allowed to be
filled with the letter "J". So only one cell i allowed. When already a cell
is filled, the a message must be poped up like "already one value entered,
only one value is allowed".

I hope somebody can help me out here!!

thanks