Thu 13 Sep 2007, 16:54Delegate James said...
James has attended:
Excel Intermediate course
Excel Advanced course
Highlighting cells
How do I highlight cells with a number over a certain value in a colour?
Tue 25 Sep 2007, 16:31Trainer Anthony said...
RE: Highlighting cells
Hi James. You need to use conditional formatting to do this. Select your cell and then select Format - Conditional Formatting. This will bring up a dialog box in which you can specific the criteria you want to follow and the formatting change you want to occur.
Hope this helps,
Anthony
