format compare
 

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

format compare
 

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




"Sam" wrote in message
om...
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