Hello,
I need to set up an excel to highlight a cells color yellow if cell A4>0 and change text to red if cell X4>Y4
I set up a conditional format with 2 conditions for each of the above.
It appears that the conditional format will only carry out the first format if both conditions are met. It will not format when both occur (Only carries out the first condition format if more than one condition is met)
Is there a way around this?
I need to set up an excel to highlight a cells color yellow if cell A4>0 and change text to red if cell X4>Y4
I set up a conditional format with 2 conditions for each of the above.
It appears that the conditional format will only carry out the first format if both conditions are met. It will not format when both occur (Only carries out the first condition format if more than one condition is met)
Is there a way around this?