formating

[stevekirk]

hi,

i would like my cell in column c to turn green if the same value is in the cell in column b


IE
b6 = 20
C6 = 20
TURN C6 GREEN

thanks

steve

[Carim]

Hi Steve,

While in cell C6, Format Conditional Formatting
Formula Is
=C6=B6
Format Patterns Green

HTH
Carim

[VBA Noob]

Hi

Try the below

Select Column C and enter in Conditional formatting

=IF(OFFSET(C1,0,-1)*COUNTIF(B:B,C1)>1,TRUE,FALSE)

Matches any value in B which is in C

VBA Noob

[stevekirk]

thanks

works great

steve

[VBA Noob]

Glad Carim and/or I helped you

VBA Noob