Forum Discussion
Conditional formatting rules, multiple conditions to check
I'd use two rules instead of the four you have. And you probably want to apply them to $J$6:$J$100 or so, instead of just to $J$6.
Leave the rule for J6>0.18 alone, and delete the other three.
Click 'New rule...'
Select 'Use a format to determine which cells to format'.
Enter the formula =AND(P6="Yes",J6>0.24).
Click Format...
Activate the Font tab.
Select red as font color.
OK your way out.
I'd use two rules instead of the four you have. And you probably want to apply them to $J$6:$J$100 or so, instead of just to $J$6.
Leave the rule for J6>0.18 alone, and delete the other three.
Click 'New rule...'
Select 'Use a format to determine which cells to format'.
Enter the formula =AND(P6="Yes",J6>0.24).
Click Format...
Activate the Font tab.
Select red as font color.
OK your way out.
HansVogelaar Awesome thanks. I got a reply on another Excel forum a few minutes before you. I ended up doing this which is essentially the same as you have said, and it works great.
