Conditional formatting in 2007

F

Fred Smith

In Excel 2007, how do I find out what condtional formatting is held in a
cell? When I highlight the cell, and go to conditional formatting, all I see
are options to enter new formatting, nothing to check what's there.

Thanks,
Fred
 
F

Francois via OfficeKB.com

Fred said:
In Excel 2007, how do I find out what condtional formatting is held in a
cell? When I highlight the cell, and go to conditional formatting, all I see
are options to enter new formatting, nothing to check what's there.

Thanks,
Fred
Click to expand...

Thats because there are no formats set.

try seting one up, then go back in.....you'll then see what its all about
 
J

Jim Rech

Pick Manage Rules from the bottom of the Conditional Formatting menu.

--
Jim
| In Excel 2007, how do I find out what condtional formatting is held in a
| cell? When I highlight the cell, and go to conditional formatting, all I
see
| are options to enter new formatting, nothing to check what's there.
|
| Thanks,
| Fred
|
 
Top