Posted to microsoft.public.excel.worksheet.functions

Rob Nance

external usenet poster

Posts: 4

Conditional Formatting Amendment

Hello

I've currently got a condition as: Cell Value = CN, applied to $H:$H (ie a whole col) but I'd like to change that to "If first character of cell = C". Haven't done this for so long that I can't seem to get the formula right. :( Help?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro Amendment.	Mattlynn via OfficeKB.com	Excel Worksheet Functions	4	September 17th 09 04:06 PM
Ron deBruins copy5 code amendment	[email protected]	Excel Programming	7	September 8th 09 10:14 PM
AMENDMENT IN MACRO	K[_2_]	Excel Programming	2	February 8th 08 09:21 AM
Formula amendment to not remove digits	Sarah (OGI)	Excel Worksheet Functions	3	August 20th 07 04:42 PM
Copy module with code - amendment	Stuart[_5_]	Excel Programming	2	November 1st 04 07:40 AM

All times are GMT +1. The time now is 06:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us