| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting:highlight row based on blank or non-blank c
Does anyone know if, and how, is possible to use Conditional Formatting
feature to automatically highlight the whole row if a specific cell in that row is non-blank (or blank)? Thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional formatting:highlight row based on blank or non-blank c
Hi,
Say the row is row 2 and the cell to be checked for blank is C2 - Select the entire row - menu Format COnditional FOrmat. the dialog pops-up. - choose "Formula Is" in the first drop down, then enter the formula: =($C2="") - click the Format button to select a format when the cell is blank - ok -- Regards, Sébastien <http://www.ondemandanalysis.com "Nat Maxwell" wrote: Does anyone know if, and how, is possible to use Conditional Formatting feature to automatically highlight the whole row if a specific cell in that row is non-blank (or blank)? Thank you! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional formatting:highlight row based on blank or non-bla
Thank you Sebastien!
And how do you denote a NON-BLANK cell inside a formula? (I guess the way to tell a formula to look for a BLANK cell is "", right?) Thank you so much! "sebastienm" wrote: Hi, Say the row is row 2 and the cell to be checked for blank is C2 - Select the entire row - menu Format COnditional FOrmat. the dialog pops-up. - choose "Formula Is" in the first drop down, then enter the formula: =($C2="") - click the Format button to select a format when the cell is blank - ok -- Regards, Sébastien <http://www.ondemandanalysis.com "Nat Maxwell" wrote: Does anyone know if, and how, is possible to use Conditional Formatting feature to automatically highlight the whole row if a specific cell in that row is non-blank (or blank)? Thank you! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional formatting:highlight row based on blank or non-bla
=$C2<""
or =NOT(ISBLANK($C2)) -- HTH RP (remove nothere from the email address if mailing direct) "Nat Maxwell" wrote in message ... Thank you Sebastien! And how do you denote a NON-BLANK cell inside a formula? (I guess the way to tell a formula to look for a BLANK cell is "", right?) Thank you so much! "sebastienm" wrote: Hi, Say the row is row 2 and the cell to be checked for blank is C2 - Select the entire row - menu Format COnditional FOrmat. the dialog pops-up. - choose "Formula Is" in the first drop down, then enter the formula: =($C2="") - click the Format button to select a format when the cell is blank - ok -- Regards, Sébastien <http://www.ondemandanalysis.com "Nat Maxwell" wrote: Does anyone know if, and how, is possible to use Conditional Formatting feature to automatically highlight the whole row if a specific cell in that row is non-blank (or blank)? Thank you! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional formatting:highlight row based on blank or non-bla
one way is: $C2<""
-- Regards, Sébastien <http://www.ondemandanalysis.com "Nat Maxwell" wrote: Thank you Sebastien! And how do you denote a NON-BLANK cell inside a formula? (I guess the way to tell a formula to look for a BLANK cell is "", right?) Thank you so much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Worksheet Functions | |||
| Conditional Formatting based on Non Blank Cells | Excel Discussion (Misc queries) | |||
| Highlight rows based on '1' or blank in all columns on a row | Excel Worksheet Functions | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Discussion (Misc queries) | |||
| Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
Linear Mode
