Investigate inherited formatting.

[James Silverton]

Hello All!

I am using an "inherited" work sheet and it is formatted so that certain
calculated values are displayed in red if they are large enough. It's
perhaps a silly question but how do I find out the details and values
used for this formatting?

Thanks in advance!

--


James Silverton
Potomac, Maryland

Email, with obvious alterations:
not.jim.silverton.at.verizon.not

 

[Don Guillett Excel MVP]

This is probably CONDITIONAL FORMATTING so select one of the
cells>goto the format menu item>conditional formatting>>>>

 

[Rick Rothstein]

I am using an "inherited" work sheet and it is formatted so that certain
calculated values are displayed in red if they are large enough. It's
perhaps a silly question but how do I find out the details and values
used for this formatting?

Another possibility is the cells are Custom Formatted something like this...

[Red][>1000]General;General

where the General parts may be any acceptable cell format. The [Red][>1000]
applies to the first format pattern (the one in front of the semi-colon) and
means if the number in the cell is larger than 1000, make it red; otherwise
apply the second listed format pattern (the one after the semi-colon).

Rick Rothstein (MVP - Excel)

 

[Rick Rothstein]

I am using an "inherited" work sheet and it is formatted

so that certain calculated values are displayed in red if
they are large enough. It's perhaps a silly question but
how do I find out the details and values used for this
formatting?

Another possibility is the cells are Custom Formatted something like this...

[Red][>1000]General;General

where the General parts may be any acceptable cell format. The [Red][>1000]
applies to the first format pattern (the one in front of the semi-colon) and
means if the number in the cell is larger than 1000, make it red; otherwise
apply the second listed format pattern (the one after the semi-colon).

Rick Rothstein (MVP - Excel)

 

[James Silverton]

Don wrote on Thu, 13 Jan 2011 05:49:26 -0800 (PST):

This is probably CONDITIONAL FORMATTING so select one of the

cells>> goto the format menu item>conditional formatting>>>>

Thank you, that worked! I had not noticed the format menu item list
could be expanded to choose "Conditional Formatting" but I now know how
to change the values if necessary.
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not