Most valuable professional
  • Hot Topics

Excel Conditional Formatting in a cell with 6 conditions

I want to formulate 6 CFs in a cell B1 to generate either of the value 1,2,3,4,5,6. 6 CFs are to be formulated to generate either of: CF1=1: A1 is less than B1; B1 is less than C1 and A1 is less than C1 CF2=2: A1 is less than B1; B1 is greater than or equal to C1 and A1 is less than C1 CF3=3: A1 is less than B1; B1 is greater than or equal to C1 and A1 is greater than or equal to C1 CF4=4: A1 is greater than or equal to B1; B1 is greater than or equal to C1 and A1 is greater than or equal to C1 CF5=5: A1 is greater than or equal to B1; B1 is less than C1 and A1 is greater than or equal to C1 CF6=6: A1 is greater than or equal to B1; B1 is greater than or equal to C1 and A1 is less than C1

This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of September 26, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel