|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 12th, 2009, 05:09 PM
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
June 12th, 2009, 05:15 PM
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
June 12th, 2009, 06:24 PM
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
June 12th, 2009, 06:29 PM
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
June 12th, 2009, 06:31 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
