macro / function?

  • Thread starter Thread starter Jignesh Vaidya
  • Start date Start date
J

Jignesh Vaidya

Hello.

A B,C,D E
LINE MINUTES
Line1 28
Line4 34
Line1
Line3 11
Line2 47
Line2

Lines are conference lines of calling customers and
coloumn E contains minutes. Empty cell in coloumn E
indicates that conference call is still in progress. I
find it very difficult handling 12 conference lines while
entering minutes once the call ends. Anyway i can
highlight the lines that are active?
Ie, Right now in Coloumn A, "line1" in third row should be
of say red colour, or should be blinking, same way "line2"
in 6th row above (since cell in the same row, coloumn E is
empty). So i can at a glance make out which line is busy.
Moreover is it possible to highlight the empty cell in the
same row with same colour?
Ie. Since line1 is in use, i assume it will blink or look
red. The cell in coloumn E, same row should have same
colour.
Problem is there are 3 coloumns in between the LINE and
MINUTES like date,time, ac/no, etc..etc So when call ends,
my employee has to move his finger on monitor
across "line1" and then enter minutes in the same row.
I went through all the functions. i dont see anything that
would help me here in this situation. I am not good with
VB or Macros. So if you post in a macro in reply, make it
so that i can simply copy paste..:-)) OR
I would also be very thankful if you can forward me to
some websites where i can find info regarding this.
Thanks.
 
You can use conditional formatting to color cells or rows
where the "Minutes" column is blank:

1. Select your range in columns A through E.
2. Go to Format Conditional Formatting.
3. Select "Formula Is" on drop-down list and insert:
=AND($A2<>"",$E2="")
4. Press the Format radio button and format as desired.
5. Press OK twice.

HTH
Jason
Atlanta, GA
 
Hi
try the following:
- select column A (e.g. cell A1:A100)
- goto 'Format - conditional Format' and enter the following formula
=$E1=""
- choose a format (e.g. red color).

Now repeat the same procedure for column E
 
awww, this simple!?!?!?!!!!
How come ideas strike you people so fast?!?! :-)
Works awesome.
Thanks Frank and Jason.
 
Back
Top