for eg:- if a staff joined on 01.01.11 and i want excel to calculate automatically his gratuity and leave salary with each day is passed.
if his salary 1000/- and joined on 01.01.11 . i want excel to calculate from his salary and starting from his joining date what will be his gratuity.
if...
i have some numerical numbers like
103001
103002
103004
103005
103006
103007
103008
103009
103010
103011
out of these numbers, i want the excel to highlight some given numbers like 103005 & 103009 & 103011 with red(and the highlight should extend to the range from COLOUMN A TO F)...
I have large number of staff ID'S (approx 1000) which are numerical and i want to highlight some staff ID's with some colour . how i can do it through a formulae ?