Conditional formatting in 2007

[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

 

[Francois via OfficeKB.com]

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

Thats because there are no formats set.

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

 

[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
|

 

[Fred Smith]

Thanks Jim. That's what I was looking for.

Regards,
Fred.