format compare

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

i have used =rand() function in cells a1 to b200.

i want to be able to compare the values in cells a1 b1 , a2 b2 , a3 b3
and so forth...using conditional formatting....

if a1 > b1 then a1 shud be red and if vice versa b1 shud be blue

how do i do this for 200 cells ?
is there an easier option ?



sam
 
Here's one way:

This assumes that you already have the Rand() function in A1:B200.

Set the conditional format for A1 to:
Cell Value Is | greater than | =B1
and format it for the color red

And set the conditional format for B1 to:
Cell Value Is | greater than | =A1
and format it for the color blue

Then copy A1:B1 and PasteSpecial/Formats into
A1:B:200

HTH,
Shockley
 
Back
Top