How do I change color pattern based upon a formula within a cell?
EXCEL - Can anybody show me the specific keystrokes to direct a cell to be a
certain color pattern based on the following example?
If the entered data in B1 is data in A1, then make the color pattern in B1
Green
If the entered data in B1 is < data in A1, then make the color pattern in B1
Red
If the entered data in B1 is = data in A1, then make the color pattern in B1
Yellow
Thanks for your help!
|