Conditional Formatting - multi conditions

[osx99]

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?

 

[GlennUK]

Have condition 1 being where both are true, and apply both sets of formatting. ( use =AND(condition1,condition2) )

Set conditions 2 and 3 as you currently have you existing conditions.

That will do it.

Cheers, Glenn.

 

[MJPPaba]

Try This...

In Conditional Formatted Cell setup
condition 1
Formula is.. =($A$4>0)*10+($x$11>$y$11)=1
formatting to be yellow background only
condition 2
Formula is.. =($A$4>0)*10+($x$11>$y$11)=10
formatting to be yellow background red font
condition 3
Formula is.. =($A$4>0)*10+($x$11>$y$11)=11
formatting to be red font only

cheers

Matthew

 

[Sawatzky]

Dear osx99,

I assume the conditional formatation bails out on the first met condition.

If you first define
condition1

if A4>0 and X4>Y4
then format
cells color yellow and change text to red

condition2
cells color yellow if cell A4>0
condition3
and change text to red if cell X4>Y4


it should work

kind regards
Astrid

 

[osx99]

Wonderful - thankyou all