I’m working on a worksheet. There are a couple of things I’m having trouble doing.
Firstly the worksheet I am working on contains 6 columns; I’d like to undertake some conditional formatting that basically changes the background colour if a value is found in the row. So if cell E1 contains the text ‘Test’ then change the background colour on cells A1:E1
The next challenge is to set the ‘wrap text’ field on all populated cells, set the column widths and then auto expand the rows so that it expands to its maximum?
I’ve read the guides but they don’t really provide the functionality I specifically need – so I wuld appreciate some examples.