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?

--
Message posted via http://www.officekb.com

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.)


New Delhi, India


"Darrell_Sarrasin via OfficeKB.com" wrote:

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?

--
Message posted via http://www.officekb.com

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


On 25 Mar, 14:59, "Darrell_Sarrasin via OfficeKB.com" <u33691@uwe
wrote:
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?

--
Message posted viahttp://www.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


Jarek Kujawa wrote:
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

On 25 Mar, 14:59, "Darrell_Sarrasin via OfficeKB.com" <u33691@uwe
wrote:
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]
--
Message posted viahttp://www.officekb.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200903/1

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




On 25 Mar, 15:41, "Darrell_Sarrasin via OfficeKB.com" <u33691@uwe
wrote:
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





Jarek Kujawa wrote:
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

On 25 Mar, 14:59, "Darrell_Sarrasin via OfficeKB.com" <u33691@uwe
wrote:
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]
--
Message posted viahttp://www.officekb.com

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200903/1- Ukryj cytowany tekst -

- Pokaż cytowany tekst -