Hi All,
Trust we are having a great day.
Small problem i can not seem to get right. There is a bunch of data we have and if any of the cells are blank we need the cell in column E to turn Red
I have a spreadsheet with data beginning on i = 3
Data Range to look for blankcells is I to O
Conditions to search the range:
If cell in column P = "Active" then
If cell in column H <> "Summer" then
Any clues?
Hi and welcome to the forum
You would do this with Conditional Formatting.
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
Now, if the cells will truly be blank - as in empty, no formula, then you can probably use this as the rule
4. enter =COUNTBLANK($A1:$F1)>0
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
Thanks for the prompt reply.
Sadly i cant use conditional formatting as its with Office:Mac and there is no formula option.
Also i need column E to return if finds blanks in range I:O
Excel for Mac does have Conditional Formatting, a VERY quick google search turned up this link, among many others...
http://www.dummies.com/how-to/conten...formattin.html
Then adjust the rangeAlso i need column E to return if finds blanks in range I:O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks