Investigate inherited formatting.

  • Thread starter Thread starter James Silverton
  • Start date Start date
J

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
 
This is probably CONDITIONAL FORMATTING so select one of the
cells>goto the format menu item>conditional formatting>>>>
 
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)
 
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?
Click to expand...

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)
 
Don wrote on Thu, 13 Jan 2011 05:49:26 -0800 (PST):
This is probably CONDITIONAL FORMATTING so select one of the
Click to expand...
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
 
Back
Top