conditional formatting

[Darrell_Sarrasin via OfficeKB.com]

I have four different things that produce the same color. basically I have
four different styles of terminations and I want the cell to turn red when it
sees them. I know how to do it individually but is it possible to do this in
one section?

 

[DILipandey]

Hi Darrell,

Choose "Formula" option, while applying conditional formattting and apply
the following logic:-

IF(or(Style1,style2,style3,style4),"True","False")

True -> will apply your conditional formatting on the respective cells.

Thanks
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[Jarek Kujawa]

Excel 2003
select A1
Format->Conditional Formatting->select FormulaIs->insert the formula
=OR(A1=1,A1=2,A1=3,A1=4)
select red color format

adjust 1,2,3,4 respectively

 

[Darrell_Sarrasin via OfficeKB.com]

Jarek this works great on one cell but the issue is that I have a range of
E13:E112 that is using it and by using this formula then it covers everything
red when I select the one.

Further Help Please

Excel 2003
select A1
Format->Conditional Formatting->select FormulaIs->insert the formula
=OR(A1=1,A1=2,A1=3,A1=4)
select red color format

adjust 1,2,3,4 respectively

I have four different things that produce the same color.  basically I have
four different styles of terminations and I want the cell to turn red when it

[quoted text clipped - 3 lines]

 

[Jarek Kujawa]

select E13, repeat steps in my previous post but change the address
from A1 to E13 before
copy the formatted cell
Edit->PasteSpecial it -> as Formats to your desired range

pls click YES if this helped you

Jarek this works great on one cell but the issue is that I have a range of
E13:E112 that is using it and by using this formula then it covers everything
red when I select the one.

Further Help Please

Excel 2003
select A1
Format->Conditional Formatting->select FormulaIs->insert the formula
=OR(A1=1,A1=2,A1=3,A1=4)
select red color format

adjust 1,2,3,4 respectively

I have four different things that produce the same color.  basically I have
four different styles of terminations and I want the cell to turn red when it

[quoted text clipped - 3 lines]