Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change color of a cell if another cell has text in it
I am trying to achieve this:
If i have text in range a5:b144 then I want to color each coresponding cell in the range d5:e144. ie: if a5 has a number in it... then d5 turns yello ie: if b33 has a number in it.. then e33 turns yello Is there a way to do this? D. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should let me change case in the cell the text is in. | Excel Worksheet Functions | |||
Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
how do i get cell to change colour when text is added to it to hi. | Excel Discussion (Misc queries) |