conditional formatting in excel 2003
 

having problems with C.F in cells, Formulaes work o.k,
Can select C.F.
Can insert Formulas in C.F
Can select Colour, BUT
No colour Shows up on any cells so C.F ed
Cells and pages are not locked
Macros work ok on all spreadsheets
Windows xp. All this worked properly some months ago
Please help.
Quandary 13 - 3 - 09

conditional formatting in excel 2003
 

Does normal color formatting (not conditional formatting) show up?

See if this is the culprit:

http://support.microsoft.com/?id=833258

--
Biff
Microsoft Excel MVP


"Quandary 11 - 3 - 07" wrote in
message ...
having problems with C.F in cells, Formulaes work o.k,
Can select C.F.
Can insert Formulas in C.F
Can select Colour, BUT
No colour Shows up on any cells so C.F ed
Cells and pages are not locked
Macros work ok on all spreadsheets
Windows xp. All this worked properly some months ago
Please help.
Quandary 13 - 3 - 09

conditional formatting in excel 2003
 

Well, this generally happens if the cell value does not match the
condition you specified in the formula of conditional formatting.
for eg. if you have formatted a cell (say A1) to show red background if
a value of 1 is entered,. but you have not supplied the value 1, then
there will be no color shown on that formatted cell…..(I think this
should be the case because you have stated that All this worked
properly some months ago)



Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com




--
Chris Bode

conditional formatting in excel 2003
 

No, Normal colour formatting does not show up. Thanks

"T. Valko" wrote:

Does normal color formatting (not conditional formatting) show up?

See if this is the culprit:

http://support.microsoft.com/?id=833258

--
Biff
Microsoft Excel MVP


"Quandary 11 - 3 - 07" wrote in
message ...
having problems with C.F in cells, Formulaes work o.k,
Can select C.F.
Can insert Formulas in C.F
Can select Colour, BUT
No colour Shows up on any cells so C.F ed
Cells and pages are not locked
Macros work ok on all spreadsheets
Windows xp. All this worked properly some months ago
Please help.
Quandary 13 - 3 - 09

conditional formatting in excel 2003
 

Thanks for trying, but still not working out.
On FORMAT Dropdown List, Select CELLS, Select PATTERNS, Select COLOUR
Sample colour VISIBLE in FORMAT CELLS WINDOW, But CELL does not change.
Selecting Font Size O.K.
Selecting Font Colour, Visable in Sample Box, But no colour change in
Selected cell.
Has a certain File in Excel been Corrupted in one way or another? If so how
do I find it.? Quandary 13 - 3 - 09

"Chris Bode" wrote:


Well, this generally happens if the cell value does not match the
condition you specified in the formula of conditional formatting.
for eg. if you have formatted a cell (say A1) to show red background if
a value of 1 is entered,. but you have not supplied the value 1, then
there will be no color shown on that formatted cell€¦..(I think this
should be the case because you have stated that All this worked
properly some months ago)



Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com




--
Chris Bode

conditional formatting in excel 2003
 

I wish to convey my apology for not trying your 833258 sooner, But Yes it does
work from the Accessability Option --- High Contrast selection to
OFF,Thankyou.
--
Quandary 30 - 3 - 09

"T. Valko" wrote:

Does normal color formatting (not conditional formatting) show up?

See if this is the culprit:

http://support.microsoft.com/?id=833258

--
Biff
Microsoft Excel MVP


"Quandary 11 - 3 - 07" wrote in
message ...
having problems with C.F in cells, Formulaes work o.k,
Can select C.F.
Can insert Formulas in C.F
Can select Colour, BUT
No colour Shows up on any cells so C.F ed
Cells and pages are not locked
Macros work ok on all spreadsheets
Windows xp. All this worked properly some months ago
Please help.
Quandary 13 - 3 - 09