IF function with Conditional Formatting

**gast261** · 01-12-2014, 04:56 PM

First off, this is my first actual post here, but I've found very helpful information in the past, so thanks to many of you for help previously given!
Now for my question...I have a schedule for my personnel. When picking their work and off days, there can only be 50% off on any given day, and only 25% off on special days and holidays. I already have the formulas in place to add the numbers and to alert me when there is an excess above 50% off. I have created an additional column("Special") that I'd like to use for the special days when only 25% can be off. I want to be able to enter "y" in this column, then have it change the formula to figure percentage and to turn red when it exceeds 25%. I have included a working copy of the roster for anyone who may be able to help.
Thanks in advance!
Garrett

**perimidt** · 01-12-2014, 06:51 PM

Originally Posted by gast261

I have created an additional column("Special")

I couldn't see that additinal coloumn so I added it in coloumn C, and added this conditional formatting:
=AND(Z7>0,25;OR(C7="Y";C8="Y"))

NEW PICKING ROSTER-Post 15-Experimental.xlsx

**FDibbins** · 01-12-2014, 06:52 PM

Hi and welcome to the forum

I dont see a column for "Special", but lets say it is in Z. Delete the CF rule that you have and use this instead...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =IF(Z8="Y",Y7>=0.025,Y7>=0.5)

**FDibbins** · 01-12-2014, 06:53 PM

Also, the formulas in V:X can be simplified to this...
=COUNTA(E7:H8)

**gast261** · 01-12-2014, 07:47 PM

Erik and Ford, thank you both so very much for your help. That got it done for me! I actually wound up integrating both solutions to give me some additional information.
I hope that you both have a great evening!
Garrett

**FDibbins** · 01-12-2014, 08:27 PM

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

IF function with Conditional Formatting

LinkBack

Thread Tools

Rate This Thread

Display

IF function with Conditional Formatting

Re: IF function with Conditional Formatting

Re: IF function with Conditional Formatting

Re: IF function with Conditional Formatting

Re: IF function with Conditional Formatting

Re: IF function with Conditional Formatting

Thread Information

Users Browsing this Thread

Similar Threads

Conditional formatting using MAX function

Conditional Formatting with IF function

Conditional formatting with NOW() function

conditional formatting with IF/AND function

Conditional Formatting - IF Function

Bookmarks

Bookmarks

Posting Permissions