So, you get red and green colored cells for instances of "I" or "A" except in
A2.
Right?
Don't know why A2 would not color Red if it indeed contains the letter I(or i,
CF is not case-sensitive).
Select A2 and check your CF formula is: for first and/or second condition.
Should read =A2="I" or =A2="A"
Gord
On Fri, 23 Apr 2004 17:44:04 -0500, djranks
wrote:
it works pefectly fine. my heading is in a1 reads' Status.
my first selection is a2 which reads I. but my formula starts working
from a3 and on. it skips a2 and does nothing with it. but it works from
a3 and so on
---
Message posted from http://www.ExcelForum.com/