changing the colour of cells depending on the content.

[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

 

[Bob Phillips]

Look at Conditional Formatting in help.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

You need to use Conditional Formatting

 

[johnny.exe]

thanks that helped alot