# Formula needed (Data red)

#### ironsides

##### Well-known Member
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

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
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.

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
but to no avail
all data remains black

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

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.

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

Matt

Replies
1
Views
240
Replies
3
Views
217
Replies
1
Views
121
Replies
8
Views
329
Replies
0
Views
220

1,203,524
Messages
6,055,910
Members
444,834
Latest member
ComputerExcel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back