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 wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200803/1

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

--
Jim
"Fred Smith" wrote in message
...
| 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
|

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

Regards,
Fred.

"Jim Rech" wrote in message
...
Pick Manage Rules from the bottom of the Conditional Formatting menu.

--
Jim
"Fred Smith" wrote in message
...
| 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
|