Investigate inherited formatting.

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
 
D

Don Guillett Excel MVP

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

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)
 
R

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)
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Tables 3
Mysteries on msnews. 2
Randomizing 3
Conditional formatting on a function 3
Checkmark question. 3
how do u make a freytag pyramid 3
Conditional formatting 4
Symbol for new line in cell 7

Top