| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formats
I'm familiar with conditional formatting, but am having issues - hoping
someone can point me in the right direction. I would like to change table data to blue italic if column O 10, but less than 12 and if O ="12", need it to be bold italic red Excel 2003 is accepting first condition, but not 2nd. Any ideas? TIA, Sandi |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formats
Isn't the first one just Equal to 11? and second one is greater than or equal to 12 -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550356 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formats
Whoops! Need to re-clarity...
I meant to say =10 (blue italic) & =12 (bold red italic) Sandi "Bearacade" wrote: Isn't the first one just Equal to 11? and second one is greater than or equal to 12 -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550356 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formats
Put Greater or Equal to 12 as first condition and then Greater or Equal to 10 as second condition Hope that helps -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550356 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formats
Thanks so much! It worked perfectly
Sandi Happy Friday! "Bearacade" wrote: Put Greater or Equal to 12 as first condition and then Greater or Equal to 10 as second condition Hope that helps -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550356 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste Special Formats Generated by Conditional Formatting | Excel Discussion (Misc queries) | |||
| Why do conditional formats appear by themselves in Excel 2003? | Excel Discussion (Misc queries) | |||
| how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
| how do i get more than three conditional formats in excel | Excel Worksheet Functions | |||
| Conditional Formats in Excel | Excel Worksheet Functions | |||
Linear Mode
