changing the colour of cells depending on the content.

  • Thread starter Thread starter johnny.exe
  • Start date Start date
J

johnny.exe

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
 
Look at Conditional Formatting in help.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Back
Top