Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format/compare | Excel Worksheet Functions | |||
how to compare time in hh:mm format using IF function? | Excel Worksheet Functions | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Compare 2 columns & format row | Excel Worksheet Functions | |||
Conditional Format ... Compare Columns? | Excel Discussion (Misc queries) |