| 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 |
| 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) | |||
Threaded Mode
