| Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free! |
MS Excel - Change text with IF
|
Original Message
|
Name: mcamax
Date: March 2, 2006 at 10:26:49 Pacific
Subject: MS Excel - Change text with IF OS: Windows 2000 ProCPU/Ram: PIII/512MBModel/Manufacturer: HP Vectra |
Comment: I know how to use an IF statement to change the value of a cell in MS Excel (Office XP). But can the color of the text be changed also? Or the background fill?
Report Offensive Message For Removal
|
|
Response Number 1
|
Name: Bryco
Date: March 2, 2006 at 15:10:14 Pacific
|
Reply: (edit)Yes using Conditional format via Format, Conditional Formatting.
You can incorporate an IF statement if needed. Bryan
 Report Offensive Follow Up For Removal
|
|
Response Number 2
|
Name: mcamax
Date: March 2, 2006 at 15:52:54 Pacific
|
Reply: (edit)Thanks, Bryan. Works great! I used an IF statement to determine the value of the cell, then conditional formatting to set the background color for two conditions.
Report Offensive Follow Up For Removal
|
Post Locked
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
Go to Office Software Forum Home
