| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
BULK Conditional Formatting - by column without going into each cell?
I've read the posts on conditional formatting for cell colour based on another cell's value (eg. set the conditional formatting to "formula is" and then "=A10" and set the colour as red / blue / whatever...), however wondering if I can do this for an entire column without individually changing the conditional formatting for each cell one by one (as there are over 400 rows). Basically I need a formula that reads the contents of column B for the particular row that is active. Can anyone help? -- Rob Moyle ------------------------------------------------------------------------ Rob Moyle's Profile: http://www.excelforum.com/member.php...o&userid=30432 View this thread: http://www.excelforum.com/showthread...hreadid=500983 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
| Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
| Conditional formatting row when cell value is an even number | Excel Worksheet Functions | |||
| Conditional formatting row if cell value in certain column is even | Excel Worksheet Functions | |||
Threaded Mode
