View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] seanryanie@yahoo.co.uk is offline
external usenet poster
 
Posts: 73
Default Change Font Colour and Background If Q


How would you include code that if the cell is blank the colour of the
cell would revert to "default" i.e. white

Problem at the moment is that if a location is selected the cell is
changed to the required colour but if the cell is changed to "blank"
the original colour remains

Also where can I obtain a list of colour numbers i.e. red=3; green=4
etc


Thanks