Macro Hell - Highlight Row Given Condition
Posted by Michael on August 28, 2001 12:45 PM
if:
A1 = 1
A2 = 0
A3 = 1
A4 = 0
then:
What is the formula/macro that would highlight row 2 & 3 with a color (any color)?
Posted by Alfredo on August 28, 2001 5:33 PM
This can be done with Conditional Formatting. Put the following formula in the FormulaIs box and pick your colour(s):-
=AND($A$1=1,$A$2=0,$A$3=1,$A$4=0)
