SCOPE Adult Day Care
New Member
- Joined
- May 16, 2002
- Messages
- 7
Howdy all -
I think I remember seeing something somewhere that you could tell Excel to highlight a cell if it contained a certain variable, however I don't remember where I saw it.
What I need is this:
Column C (total hours)= Column B (arrival time) minus Column A (departure time) - all times are in 24 hour format.
I would like the Cells in Column C to automatically become highlighted with a color (yellow) if the cell's contents are below 5:00.
If anyone can help me out, I would greatly appreciate it!!!
Dennis
I think I remember seeing something somewhere that you could tell Excel to highlight a cell if it contained a certain variable, however I don't remember where I saw it.
What I need is this:
Column C (total hours)= Column B (arrival time) minus Column A (departure time) - all times are in 24 hour format.
I would like the Cells in Column C to automatically become highlighted with a color (yellow) if the cell's contents are below 5:00.
If anyone can help me out, I would greatly appreciate it!!!
Dennis