| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMAT ENTIRE ROW BASED ON SPECIFIC TEXT
EXCEL 2007
I need to have an ENTIRE row bolded IF anywhere in the row is the word TOTAL... I tried various CF but I cannot get it to apply to the entire sheet and when I look in the forum for the answer, even though it's probably glaring at me, I don't see how to do it.. This would be for anytime the subtotal function is run from the DATA tab.. we use this quite often, but it would be nice to have the total rowS show more... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMAT ENTIRE ROW BASED ON SPECIFIC TEXT
1. Select cell A1. Then press (Ctrl+A) to select all cells
2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =COUNTIF(1:1,"*TOTAL*") 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK You can remove the * from the formula if you are looking for a whole cell match. If this post helps click Yes --------------- Jacob Skaria "Tree" wrote: EXCEL 2007 I need to have an ENTIRE row bolded IF anywhere in the row is the word TOTAL... I tried various CF but I cannot get it to apply to the entire sheet and when I look in the forum for the answer, even though it's probably glaring at me, I don't see how to do it.. This would be for anytime the subtotal function is run from the DATA tab.. we use this quite often, but it would be nice to have the total rowS show more... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMAT ENTIRE ROW BASED ON SPECIFIC TEXT
This is great! Works very well... now, if I want to run this everytime I do
this - I would just record it as a macro and then run that.. yes? Thank you very much Jacob.. "Jacob Skaria" wrote: 1. Select cell A1. Then press (Ctrl+A) to select all cells 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =COUNTIF(1:1,"*TOTAL*") 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK You can remove the * from the formula if you are looking for a whole cell match. If this post helps click Yes --------------- Jacob Skaria "Tree" wrote: EXCEL 2007 I need to have an ENTIRE row bolded IF anywhere in the row is the word TOTAL... I tried various CF but I cannot get it to apply to the entire sheet and when I look in the forum for the answer, even though it's probably glaring at me, I don't see how to do it.. This would be for anytime the subtotal function is run from the DATA tab.. we use this quite often, but it would be nice to have the total rowS show more... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Condintional Format Entire Row based on Value in Cell | Excel Programming | |||
| Conditional format an entire row based on one cell | Excel Worksheet Functions | |||
| Conditional format based on entire row | Excel Worksheet Functions | |||
| Macro - delete entire row which contain a specific text | Excel Worksheet Functions | |||
| Can I format an entire row based on the value of a single cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
