View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default why can't I change the color of a cell?

Conditional Formatting must be applied. Go to the problematic cell, click
Format Conditional Formatting to see the CF. Remove the conditional
formatting. Click on that same cell, get the black cross (lower right) then
left-click and fill down or fill right and click on €˜Fill Formatting Only
(this will wipe out the Conditional Formatting). Experiment. Repeat. You
should be back in business in no time!

HTH,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Luke M" wrote:

Check under Format - Conditional formatting to see if any fills are being
applied that way.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kel" wrote:

I changed the color in the fill color options however it doesn't appy the
change to the selected cell. Any suggestions?