| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell colour depending on another cells value... | Excel Discussion (Misc queries) | |||
| changing the way Excel displays selected cells | Excel Discussion (Misc queries) | |||
| exchange content of cells | Excel Discussion (Misc queries) | |||
| Excel-how (find/replace) for multifmat cells w/o changing fmat | Excel Discussion (Misc queries) | |||
| copying content of cell automatically to multiple cells | Excel Worksheet Functions | |||
Linear Mode
