Conditional Formatting

[rlapi051]

Here is my chart:

Amount Paid	Paid (Yes/No)
$100	YES (color yellow)
	NO (color red)
$400	YES (color yellow)

How do you make an if then statement, so that when the cell is blank in column "Amount Paid", it has the word "NO" and the cell is shaded red.

Then when I put any amount in the column "Amount Paid", it changes to YES and the cell is shaded yellow.

If someone could please help me with this formula, I would be much appreciative.

Thanks!

[MarvinP]

Hi,

It looks like you want Conditional Formatting. See the attached with an example. You will need to find Conditional Formatting and the rules. Also look in Col B for the formula that puts Yes or No.

[rlapi051]

Yes the words "YES" and "NO" are showing up appropriately.

How were you able to get the colors to show up?

Thanks for your help!

[rlapi051]

I was able to figure out the Conditional Formatting!

Thanks for your help!

[wrightln]

How do I use a conditional formula to change the cell colors? Do I need to use the hexadecimal code?

[rlapi051]

No just click on "conditional formatting/highlighted cell rules/text that contains" under home and type in the word you want it to remember and your color choice.

[FDibbins]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[FDibbins]

@ rlapid051 and wrightin...

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc