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
|