conditional formatting in excel 2003

  • Thread starter Quandary 11 - 3 - 07
  • Start date
Q

Quandary 11 - 3 - 07

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
 
C

Chris Bode

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



Chris
 
Q

Quandary 11 - 3 - 07

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
 
Q

Quandary

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.
 
Top