I have a conditional formating rule for 100 cells. It equls to TRUE and shows RED if the cells contains something I want to get a warning about.
Then I have another conditional formating rule for 10 other cells. It equls to TRUE and shows RED if the cells contains something I want to get a warning about.
Finally I have one cell. I want this cell to be RED when any of the two conditioning rules above are true in any cell.
How can I do this or something like it?
Just combine the same two conditions with an OR
=OR(condition1,condition2)
format as red
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Also, you didnt say what the formulas were, but CF only ever works on TRUE or FALSE, so if your formula says something like...
=F(A1=1,TRUE,FALSE)
then you can simplify that to...
=A1=1
This will produce a TRUE or FALSE answer which CF will use
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
I want Excel to turn red whole row like this.. the row which contains 0 in Column K...
like this...shown in Img Excel(want this).PNG
...
bt because headings are merged.. this happens..
Excel 2(dont want).PNG
help out.
SHeet : working inv list.xlsx
Last edited by sufian.naeem; 09-12-2014 at 01:30 PM.
Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
Also, not all members are able - or willing - to download files from file-hosting sites. upload your file to the forum please
sure . . .
y not...
Try this in CF as a new rule/use formula...
=AND(ISNUMBER($A3),$J3=0)
sufian.naeem, I just noticed that you have posted your question on some1 elses thread. THis is called high-jacking and is against rule 2 of this forum. For future reference, please start your own thread wit your question, and if you feel it relevant, you can include a link back to this 1
Really sorry bout that, I will be really careful next time...Sorry about everything...Originally Posted by FDibbins
No problem, thanks for the understanding
I don't think this works. I have one conditioning rule in 100 cells. The first cell where I have it is J11 and it says =Abs(J11)-K11<AverageRate
Since this rule exists in 100 cells there are 100 unique formulas:
=Abs(J11)-K11<AverageRate
=Abs(J12)-K12<AverageRate
=Abs(J13)-K13<AverageRate
=Abs(J14)-K14<AverageRate
=Abs(J15)-K15<AverageRate
I my "master cell" I want conditional formatting to apply if any of these formulas are true, in other words if any of these cells have conditional formating.
Is this possible to achieve?
With CF, you apply the rule to the 1st cell (under Rules), then define the range you need it to work on (under applies to)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks