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 -