CONDITIONAL FORMATTING FORMULA
Please help me provide a formula that will change color of data in column A once text "Confirmed" in entered in Column B:
COLUMN A COLUMN B
6/1/2012 Available
6/2/2012 Confirmed
6/3/2012 Tentative
Thanks
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 563 guests online.
New Excel Experts
Current Excel / VBA Jobs |
CONDITIONAL FORMATTING FORMULAPlease help me provide a formula that will change color of data in column A once text "Confirmed" in entered in Column B: COLUMN A COLUMN B Thanks |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
take a look here: 25. Excel
take a look here:
25. Excel Tips - Conditional formatting