| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONDITIONAL FORMAT BASED ON 2 CELLS
Even to me this seems like it should be simple but I'm not able to make it
work: Given A6:L6, I would like B6 through L6 (independent of each other) to be shaded red IF A6 contains any value AND the 2nd cell is blank. If A6 is blank OR second cell contains any value then no shading. -- THANKS! Steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONDITIONAL FORMAT BASED ON 2 CELLS
Use this for FormulaIs:
=AND($A$6<"",$B$6="") HTH, Paul "Steve_n_KC" wrote in message ... Even to me this seems like it should be simple but I'm not able to make it work: Given A6:L6, I would like B6 through L6 (independent of each other) to be shaded red IF A6 contains any value AND the 2nd cell is blank. If A6 is blank OR second cell contains any value then no shading. -- THANKS! Steve |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONDITIONAL FORMAT BASED ON 2 CELLS
Use an IF((isblank),1,0) Using conditional formatting 1 = Red
However, conditional formatting refers to a value in its current cell. A1 = 0 and B1 = 1, c1 is blank. Even though B1 has a value of 1, C1 will not be RED as its cell value is blank. "Steve_n_KC" wrote: Even to me this seems like it should be simple but I'm not able to make it work: Given A6:L6, I would like B6 through L6 (independent of each other) to be shaded red IF A6 contains any value AND the 2nd cell is blank. If A6 is blank OR second cell contains any value then no shading. -- THANKS! Steve |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONDITIONAL FORMAT BASED ON 2 CELLS
A half day problem solved in under 13 minutes! Thanks so much! (I had to
pull a couple $'s out for copying purposes but You got me where I needed to go!) -- THANKS! Steve "PCLIVE" wrote: Use this for FormulaIs: =AND($A$6<"",$B$6="") HTH, Paul "Steve_n_KC" wrote in message ... Even to me this seems like it should be simple but I'm not able to make it work: Given A6:L6, I would like B6 through L6 (independent of each other) to be shaded red IF A6 contains any value AND the 2nd cell is blank. If A6 is blank OR second cell contains any value then no shading. -- THANKS! Steve |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONDITIONAL FORMAT BASED ON 2 CELLS
No problem. Thanks for the feedback.
"Steve_n_KC" wrote in message ... A half day problem solved in under 13 minutes! Thanks so much! (I had to pull a couple $'s out for copying purposes but You got me where I needed to go!) -- THANKS! Steve "PCLIVE" wrote: Use this for FormulaIs: =AND($A$6<"",$B$6="") HTH, Paul "Steve_n_KC" wrote in message ... Even to me this seems like it should be simple but I'm not able to make it work: Given A6:L6, I would like B6 through L6 (independent of each other) to be shaded red IF A6 contains any value AND the 2nd cell is blank. If A6 is blank OR second cell contains any value then no shading. -- THANKS! Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format based on other cells | Excel Discussion (Misc queries) | |||
| Conditional format a cell based on another range of cells | Excel Worksheet Functions | |||
| Conditional Format based on Other Cells | Excel Discussion (Misc queries) | |||
| Conditional Format based on 3 other cells. | Excel Discussion (Misc queries) | |||
| Conditional Format to change entire row based on one cells data | Excel Discussion (Misc queries) | |||
Linear Mode
