Excel Conditional Formatting

[ziad alsayed]

dear all

in cell A1 i have a number and in cell A2 a target related to cells A1

i need to color the number in A2 in 3 different color, if it is 75% of A1, if it is = to A1 and if it is greater than A1.

appreciate your help

 

[storm925]

Here are the 3 conditional formatting formulas...

=IF(A2/A1=0.75,TRUE,FALSE)

=IF(A1=A2,TRUE,FALSE)

=IF(A2>A1,TRUE,FALSE)

 

[ziad alsayed]

thanks, but this is not working.
i have number so 0.75 will not work.
about the 3 formula , do you mean i have to put 3 condition??
i think it shoud be one formula.

 

[MrBill11]

Ziad,
In Excel 2007 you can use the formatting tool. Format A2 as follows using three different conditions; (1) Cell Value is Between 75 & 99 color Red, (2) Cell Value is Equal to 100 color Green, (3) Cell Value Greater Than 100 color Yellow.

 

[ziad alsayed]

thanks all for your input,

may be i didn't explain clearly,below is what i have

still appreciate you input

Excel Workbook
	A	B
1	OT Actual	OT taget
2	10	7.5
Sheet2

Excel 2010

 

[MrBill11]

Ziad,
I think the three different conditions will still work. You will just need to change the numbers.

 

[ziad alsayed]

dear all

ths below works, i put 3 conditions

1- =IF(AND(B2>(A2*0.5),B2<(A2*0.75)),TRUE,FALSE)
2-=$B$2>$A$2
3- =$B$2>($A$2*0.75)

thanks for all you input

i will try now to do it in one conditon