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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
BULK Conditional Formatting - by column without going into each ce
If you want D1 to change if B1 is greater then 0, D2 to change if B2 is
greater then 0, etc. Click on the column and "CF" with this =sum(a10). It should "CF" the whole column. "Rob Moyle" wrote: 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 |
#3
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). What I do is first apply conditional formatting to A1, then use the "Format Painter" button to apply the CF to the column as a whole. Format Painter is the command button that looks like a paint brush. Select A1, click the command button, and click on the "A" header for the column. As long as the cell references in the CF formula are relative, painting adjusts them as it paints. |
Reply |
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 |