Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Hey there... I'm trying to conditionally format multiple cells but am having
issues. The format painter does not work properly. Is there a way to do it for more than one cell at a time? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Refer
http://www.contextures.com/xlCondFormat01.html If this post helps click Yes --------------- Jacob Skaria "it''''''''sh hardy" wrote: Hey there... I'm trying to conditionally format multiple cells but am having issues. The format painter does not work properly. Is there a way to do it for more than one cell at a time? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Jacob -
I tried going to that site but it's not working the way I need it to. I have a sheet that would highlight the highest number in a row for instance F3-F12 but it takes forever to complete one cell at a time "Jacob Skaria" wrote: Refer http://www.contextures.com/xlCondFormat01.html If this post helps click Yes --------------- Jacob Skaria "it''''''''sh hardy" wrote: Hey there... I'm trying to conditionally format multiple cells but am having issues. The format painter does not work properly. Is there a way to do it for more than one cell at a time? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
F3:F12 is not a row, its a column. Which do you want?
Select a single cell (say A2) and Format - Conditional Format Formula is: =A2=MAX(2:2) for a row, if you meant column =A2=MAX(A:A) Select pattern, click 'ok' Note that lack of asbolute references (the $ symbols). You can now use the format painter to copy this to any other cell you need. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "it''''''''sh hardy" wrote: Jacob - I tried going to that site but it's not working the way I need it to. I have a sheet that would highlight the highest number in a row for instance F3-F12 but it takes forever to complete one cell at a time "Jacob Skaria" wrote: Refer http://www.contextures.com/xlCondFormat01.html If this post helps click Yes --------------- Jacob Skaria "it''''''''sh hardy" wrote: Hey there... I'm trying to conditionally format multiple cells but am having issues. The format painter does not work properly. Is there a way to do it for more than one cell at a time? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Yeah sorry column! lol! so use the bottom format, and do not use $?
"Luke M" wrote: F3:F12 is not a row, its a column. Which do you want? Select a single cell (say A2) and Format - Conditional Format Formula is: =A2=MAX(2:2) for a row, if you meant column =A2=MAX(A:A) Select pattern, click 'ok' Note that lack of asbolute references (the $ symbols). You can now use the format painter to copy this to any other cell you need. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "it''''''''sh hardy" wrote: Jacob - I tried going to that site but it's not working the way I need it to. I have a sheet that would highlight the highest number in a row for instance F3-F12 but it takes forever to complete one cell at a time "Jacob Skaria" wrote: Refer http://www.contextures.com/xlCondFormat01.html If this post helps click Yes --------------- Jacob Skaria "it''''''''sh hardy" wrote: Hey there... I'm trying to conditionally format multiple cells but am having issues. The format painter does not work properly. Is there a way to do it for more than one cell at a time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |