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

changing the colour of cells depending on the content.
 

Look at Conditional Formatting in help.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"johnny.exe" wrote
in message ...

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

changing the colour of cells depending on the content.
 

You need to use Conditional Formatting

"johnny.exe" wrote:


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

changing the colour of cells depending on the content.
 

thanks that helped alot :)


--
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