Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the Row Colour, using a cell condition
Is it possible to change the colour of a row (to say light gray) when a condition has been reached in a cell on that row ??? Example, if a cell has a Yes/No, and when you select yes, the whole row changes colour to say gray or any colour .... Hope you can help me on this. Cheers -- belgarth58 ------------------------------------------------------------------------ belgarth58's Profile: http://www.excelforum.com/member.php...o&userid=31280 View this thread: http://www.excelforum.com/showthread...hreadid=509481 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the Row Colour, using a cell condition
Select the entire row, say 12, FormatConditional Formatting Change from Cell Value Is to Formula is. If F12 is where your Yes/No is then =$F$12="Yes" Select the formatting you want by selecting "Format". Select OK. Select OK again. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=509481 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change the colour of text in cell for minus figure | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) |