Changing cell's color when formula meets certain conditions

**Jumbala** · 03-23-2010, 03:13 PM

Hi guys!

I was wondering if there was a way to make it so my cell's background changed color when the formula in it met certain conditions...

Example: I want cell A1 to becomre gray when cell A30 has "absent" written in it.

How would I go about doing that?

Thanks a lot in advance!

**royUK** · 03-23-2010, 03:16 PM

use Conditional Formatting

http://excel-it.com/excel_conditional_formatting.htm

**Jumbala** · 03-23-2010, 05:04 PM

I didn't know you could do that considering I'm fairly new with Excel.

Thank you very much, your help is very appreciated!

**royUK** · 03-23-2010, 06:50 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save