Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() ::Hi, I have a spreadsheet with circa 11,000 rows, approx. 6 columns. Some of the data MAY contain values that begin with a blank space, e.g. the cell may look like (ignore quotes) \" Fred\" when it should be \"Fred\" Is there an easy way to change the cell colour to Red for all cells in a spreadsheet where the first character is blank ? Thanks in advance for your kind help. Matt:: -- bvinternet ------------------------------------------------------------------------ bvinternet's Profile: http://www.excelforum.com/member.php...o&userid=25525 View this thread: http://www.excelforum.com/showthread...hreadid=389620 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Skip blank cells in diagrams | Charts and Charting in Excel | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
What function can make cells shift up when they are blank? | Excel Worksheet Functions | |||
how do you ignore blank cells in formulas | Excel Discussion (Misc queries) | |||
Blank cells? | Excel Worksheet Functions |