Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating with text
I have two columns of data (A:B), and want to highlight values in Col B in
coloured text, where the adjacent cell in Col A contains data entered in brackets. The data in column A is a mixture of numbers and text and formatted as 'General' so that a number in brackets does not appear as a negative value. I've used CF before but can't seem to enter a formula that works. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating for text | Excel Worksheet Functions | |||
text conditional formating | Excel Worksheet Functions | |||
Conditional formating with TEXT | Excel Discussion (Misc queries) | |||
Conditional formating based on text | Excel Worksheet Functions | |||
Conditional Formating when result is text | Excel Worksheet Functions |