Find Command, shading a Table

lessonjack

New member
Local time
4:24 PM
Messages
1
I have always loved the FIND command when working with rosters of names on a table for scheduling. This command still works in Office 2010 but I can't shade EVERY table box for the name I've found. AS an exam0ple, if I have "Susie" scheduled for an activity 9 times on the same table in random cells, I can FIND her names on the table, but I used to be able to shade/color in her cells on the schedule. Does someone else know how to do this?
 

My Computer

OS
windows 7 professional 64 bit
Are you using Word or Excel?
 

My Computer

Computer Manufacturer/Model Number
HP Pavilion p6040a
OS
Windows 7 Professional x64, SP1
CPU
Intel Core 2 Duo E7400 2.8GHz
Motherboard
FOXCONN Napa
Memory
4GB
Graphics Card(s)
ATI Radeon HD3540
Don't believe Word tables have that as standard feature.

Very easily done in Excel using conditional formatting ie.
1. Select entire cell range
2. Set selection criteria value
3. define color to set those rows matching the selection value

Good luck!
 
Last edited:

My Computer

Computer Manufacturer/Model Number
HP Pavilion p6040a
OS
Windows 7 Professional x64, SP1
CPU
Intel Core 2 Duo E7400 2.8GHz
Motherboard
FOXCONN Napa
Memory
4GB
Graphics Card(s)
ATI Radeon HD3540
Back
Top