LucidCheetah
New Member
- Joined
- Dec 11, 2017
- Messages
- 15
[FONT=Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, Courier New, monospace, sans-serif]=IF(B2="X",IF(B3="Y", TRUE, FALSE),FALSE) then select the colored background if the condition is met works for me to get one colored background.[/FONT]
[FONT=Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, Courier New, monospace, sans-serif]Say 'Sheet2'!B2="X" I can set the cell background to Red for example. What if I also want the condition where 'Sheet2'!B2="Z" to shade the cell in Blue. When i try setting two separate conditional rules to the cell, one just seems to overwrite the other. Can I do this all in a single line, on a single conditional rule? [/FONT]
[FONT=Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, Courier New, monospace, sans-serif]Say 'Sheet2'!B2="X" I can set the cell background to Red for example. What if I also want the condition where 'Sheet2'!B2="Z" to shade the cell in Blue. When i try setting two separate conditional rules to the cell, one just seems to overwrite the other. Can I do this all in a single line, on a single conditional rule? [/FONT]