Conditional Formatting

[mhartle]

Hello,

I'd like some help with a conditional formatting issue.

1. I enter some text e.g. ART in a cell (perhaps A1)

I would like excel to find all the ART cells in a certain range and highlight them (red).

But I would like to be able to change that cell to (GEO) and the excel highlights all the GEO cells in the same range?

Thank you,

mhartle

[jeffreybrown]

Try

Conditional Formatting

• Highlight applicable range >> A2:H100
• Home Tab >> Styles >> Conditional Formatting
• New Rule >> Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =A2=$A$1
• Format… [Number, Font, Border, Fill]
• OK >> OK

[mhartle]

That works

Thanks Jeff

[mhartle]

Jeff and TMS, PLEASE FIND MY WORKBOOK IN ATTACHMENTS

Sorry guys but this doesn't work

I need excel to do the following

When I type RUS into search box 1, I need excel to highight all the RUS in the subject table

Any ideas?

Thank you both

MHartle

[TMS]

Select all the cells in the range A1:I20 or whatever.

Use a CF formula: =AND($A$1<>"",A1<>"",$A$1=A1) ... and pick a format/colour.

Cell A1 and any matching cells will be highlighted. A1 will clearly match $A$1 so, as soon as data is entered into A1, it will be highlighted.


Regards, TMS

[TMS]

Note that, with Jeff's formula, when A1 is blank, all blank cells in the range will be highlighted

Regards, TMS

[jeffreybrown]

Highlight C3:F10 and then the condition is =C3=$C$2

[mhartle]

Thank you Jeff

MHartle

[jeffreybrown]

You are welcome