Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formula to fill color in a cell
- Thread starter mlocurci
- Start date
dianemarie
Instructor
Hi Michael, Excel has a very easy built-in function for this. It's under Format, and it's called Conditional Formatting. The dialog box walks you through the steps, it's very self-explanatory. You can set the IF criteria to a number or text. You might want to take a look at that. Just be aware you need to select the range you want to apply the conditional formatting to, or it will only apply to the selected active cell.
- Status
Similar threads
- Locked
- Question
