View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
johnny.exe
 
Posts: n/a
Default changing the colour of cells depending on the content.


hi
i'm working on a spreadsheet, if the cell in question say 'C15' says
'paid' i would like that cell to turn the colour green for example. if
it said 'unpaid' i would like it to turn the colour red.
if possible it would be better for the cell to be all red or green
rather that just a boarder or text as the chosen colour.
can this be done or not?
thanks, johnny


--
johnny.exe
------------------------------------------------------------------------
johnny.exe's Profile: http://www.excelforum.com/member.php...o&userid=30775
View this thread: http://www.excelforum.com/showthread...hreadid=504416