In Conditional Formatting choose formula and enter
=COUNTIF($A$1:$A$11,$B$2)0
and set background color to green!
Regards,
Stefi
€˛Big Rick€¯ ezt Ć*rta:
I have a range of 11 random numbers (but all different) in cells (A1:A11)
In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.
Thanking you in anticipation.
--
Big Rick
|