functions

[todd]

I am making a training matrix with several employees. I
have employees listed in rows and training courses listed
in columns. An x is placed in the training that each
employee has had. I also have a total row, showing the
total number of employees having taken each particular
course. Below the total is a minimum number of employees I
want to have taken each course. Is it possible to compare
the total to the minimum and return a value in red if the
total is < than the minimum of black if the total is >=
the minimum?

 

[Frank Kabel]

Hi
lets assume your totals are in the range B20:X20 and the minimum values
are in B21:X21. try the following
- select the cells B20:X20
- goto 'Format - Conditional Format'
- enter the formula
=B20<B21
- choose a format (e.g. red color)

You may also have a look at
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html

 

[todd]

Thanks for the help

-----Original Message-----
Hi
lets assume your totals are in the range B20:X20 and the minimum values
are in B21:X21. try the following
- select the cells B20:X20
- goto 'Format - Conditional Format'
- enter the formula
=B20<B21
- choose a format (e.g. red color)

You may also have a look at
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html


--
Regards
Frank Kabel
Frankfurt, Germany



.