Conditional Format based on a list

[melnikok]

I am try to take user input from one cell and match it to several columns turning the matches cells to a Red background. I have attached a file to help explain better. Thanks for any help you can give.

Ken

[VBA Noob]

See if attach helps

VBA Noob

[melnikok]

I see what you did, thanks! But I need it to span the whole column. What I mean is that if something is typed in E1 or E2 or E3... and so on. Basically as people type something in column E I want it to start filling in with red. Is that possible?

Thanks,
Ken

[manny_cb]

see if this help.. select columns C to F or wateevr

go to format > Confitional Formatting >

Formula is: =COUNTIF($A:$A,C1)

change pattern color hit ok


so any value you will type in column A .. if it exists anywhere in Columns A to F will change color.. hope that helps ?

[manny_cb]

ok read your problem wrong... this is what you do

Select column A :

Format > Condition Formatting :
Formula is : =COUNTIF($E:$E,A1)
Select Color etc.. hit OK

Select column C :

Format > Condition Formatting :
Formula is : =COUNTIF($E:$E,C1)
Select Color etc.. hit OK

now anyting you type in column E will make column A and C go red if it exists