Conditional Formatting Question
I have a spreadsheet that I want the top cell of that column font to turn red if in that same column a specific cell meets the criteria of = to or greater than 5. So here, if D2 was 6, then D1 font would turn red.
A B C D E F G
1 ROOM NUMBER: score: 310a 310b 311a 311b 312a
2 TOTAL RN ACUITY: 0 0 0 0 0
Thank you!!
In Cf for Cell D1 use
=D2>=5
format red
Life's a spreadsheet, Excel!
Say thanks, Click *
Doesn't work. Sorry, I am attaching the actual spreadsheet so you can see where I got my information. Concept is the same.
Not exactly sure where you want to apply this, but assuming it is for D1:AK1...
1. highlight the range you want to apply the conditional formatting to (D1:AK1)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =MAX(D$2:D$30)>5 format fil as requited
If you dont want to include the total in row 30, adjust accordingly
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Okay, that sort of worked. What I want is if my total in the RN Acuity field = or greater than 5, the room number will turn red. For that row. If it needs to be the whole row, that is fine, I really want it to be just the room number. So, in my spreadsheet, if row 31 (any column) has a score equal to or greater than 5, then row 1 to the corresponding column that was equal to or greater than 5, will turn red. The result I got from the above formula was it turned the first column red.
If you applied the CF exactly as I said, then it will turn a cell in D1:AK1 *red* if there is any value in the corresponding row beneath, that is greater than 5 (you could change that to >=). If applied correctly, it should not change an entire column
Okay, I applied it and it did do just that cell. Sorry, I was doing something wrong before. However, it is only doing it for greater than 5, I need to include 5. I think I can fix that. And the other thing, I don't want it to be the total from row 30, I want it to be the total from row 31 only. Is that possible?
Last edited by cadustin; 06-19-2013 at 02:04 PM.
deleted....
change the rule to...=D$31>=5
Re: Conditional Formatting Question
Thank you FDibbin! I just moved the row up one that I wanted to calculate off of. It works great! Thank you so much for helping me with this one!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks