Formula needed (Data red)

[ironsides]

Col AA
Starts Line 7

I need conditional format to make data

BBBR
BRRR
RRBR
RRRB
RRRR

in this col color red

all other data remain black

 

[gbutton]

Highlight the data set. Go to the Home Tab. Click Conditional Formatting. Click New Rule. Click Use Formula to Determine which cells to format.

Enter this formula:
=OR(A1="BBBR",A1="BRRR",A1="RRBR",A1="RRRB",A1="RRRR")

Click Format... Change the font color or fill color to red. Click ok. Click ok.

That should work.

 

[ironsides]

Highlight the data set. Go to the Home Tab. Click Conditional Formatting. Click New Rule. Click Use Formula to Determine which cells to format.

Enter this formula:
=OR(A1="BBBR",A1="BRRR",A1="RRBR",A1="RRRB",A1="RRRR")

Click Format... Change the font color or fill color to red. Click ok. Click ok.

That should work.

data is text
I cleared previous conditioning in that col
and used your formula
but to no avail
all data remains black

 

[Joe4]

Did you update the cell references so that they match where the first cell in your range?
Are you sure that you selected a Formatting option (I am embarrassed to say that on occasion I have spent so much time on the formula, that I format to choose a format option)?
Are you sure that your entries are exactly 4 characters in length (and there aren't any spaces or other special characters at the beginning or end)?

 

[gbutton]

If the data isn't stored in column A, then you'll need to replace "A1" with the column Letter.

So data in C:C would use C1 instead.

 

[ironsides]

gbutton and joe4 works well when I made the adjustment from A to AA Thanks very much

Matt